Viewing 15 posts - 4,096 through 4,110 (of 7,429 total)
Verify you are using TCP/IP to make the connection and not netbuei or a named entry. Also, did you upgrade you client tools to 2000 from 7?
December 1, 2002 at 8:45 pm
Duplicate post, please see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8471&FORUM_ID=9&CAT_ID=1&Topic_Title=Need+help+moving+a+table+to+another+filegroup&Forum_Title=General. Can an admin please lock.
December 1, 2002 at 8:43 pm
Unfortunatley no clean way to script the transfer of all permissions, constraints, keys and triggers. EM offers you the best solution or possible DMO could offer a quick and usefull...
December 1, 2002 at 8:42 pm
Why would you want two timestamps anyway? What is the point you are trying to accomplish as there may be a solution you missed.
December 1, 2002 at 8:41 pm
Even thou opensource, if used in any commercial venture it does require licensing. It is a good place for a developer to get a basic understanding of desing and the...
December 1, 2002 at 8:40 pm
Try these
Setting Up Transactional Replication: A Step-by-step Guide http://www.databasejournal.com/features/mssql/article.php/1438201
Setting Up Merge Replication: A Step-by-step Guide http://www.databasejournal.com/features/mssql/article.php/1438231
Setting Up Snapshot Replication: A Step-by-step Guide http://www.databasejournal.com/features/mssql/article.php/1458491
December 1, 2002 at 8:32 pm
Sometimes it can, the optimizer is really good and gets better each new SQL version. But from 7 and 2000 I have found a few occasion where controlling the order...
December 1, 2002 at 8:28 pm
Are they being logged in under sa inside the app or their own account. If their own then try setting the user password for the DTS package and running. There...
December 1, 2002 at 8:09 pm
The only time should reappear is if their account is removed or the password changed.
December 1, 2002 at 8:07 pm
Better than building from a known is to download a free set of encryption routines from a trusted source. (Laughing hysterically cause I said trusted) CAPICOM is part of the...
December 1, 2002 at 8:06 pm
Funny, I passed along and heard back from them. No promises in 2KSP3 (even thou that is the channel I passed on to) but they did state they would look...
December 1, 2002 at 7:57 pm
Me I am usually setting up vies to provide specific columns 99% of the time and it just was adopted to use the other way instead of *. I have...
December 1, 2002 at 7:56 pm
How does your process work? If a job what ouput does the job give and does it show running. If an outside app what happens if you stop and start...
December 1, 2002 at 7:53 pm
Make sure you are running TCP/IP on the clients and do a test ping to see how long a response takes.
December 1, 2002 at 7:48 pm
You could also place in a a seperate filegroup and backup that file group. Check out BOL Topics "How to back up files and filegroups (Transact-SQL)" and "How to restore...
December 1, 2002 at 7:46 pm
Viewing 15 posts - 4,096 through 4,110 (of 7,429 total)