Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dynamically creating a table
You wouldn't give it a star ;-)- ukwiz
- Post #4
- Forum: Microsoft SQL Server: Programming
-
NTEXT into a SELECT
Seeing the full select statement might help to diagnose this ;-)- ukwiz
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Dynamically creating a table
You could try something along these lines... create procedure #test @sqlstring nvarchar(4000) = 'CREATE TABLE [TRK3_AUTHS_MISSING_MEMBERS_Jun 19 2003 1:34PM]( [subscriber_ien] numeric(10,0), [hmo] varchar(255), [con] numeric(10,0), [effective] datetime, [termination] datetime, [emp]...- ukwiz
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Linked Server DTS like function
Sounds like you need transactional replication. From BooksOnline: Transactional Replication With transactional replication, an initial snapshot of data is propagated to Subscribers, and then when data modifications are made at the Publisher, the individual transactions are captured and...- ukwiz
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Setting Up a SQL Database
You should at least split your Access application. I am assuming that your front end is written in Access, so if you do the split, the data can be migrated up to SQL Server, and you can then link your tables pointing to SQL server as the backend rather than the split Access database. Hope this...- ukwiz
- Post #8
- Forum: Microsoft SQL Server: Programming
