Viewing 15 posts - 1,201 through 1,215 (of 1,335 total)
Better schedule your DBCC job to run in all servers. By this way you guarantee the same.
May 24, 2007 at 10:48 pm
use ST XACT_ABORT ON and then try executing the query for transactional related errors.
Also i do hope as u said u have to create the view before using it else...
May 11, 2007 at 2:50 am
1. Create a linked server
2. Use the four part naming convention to access the remote server.
3. Use table alais for refer the table and column names as you say that...
May 11, 2007 at 2:40 am
Just backup the database from the 2000 server and restore the backup file in sql server 2005. this should be doing fine for your requirement.
May 10, 2007 at 11:45 pm
The TRY...CATCH block in sql server 2005 needs SET XACTABORT set to be on so that the rollback transaction can be handled in the catch block of the TSQL statement....
May 10, 2007 at 11:38 pm
check if the path is correct in master..sysaltfiles table. it where ur ldf file will be created.
May 3, 2007 at 1:44 am
try ping the smtp server. if pinging successful. Then try telnet smtp server 25. Port 25 is by default used as the smtp port if telnet is successful with that...
May 3, 2007 at 1:40 am
Answer for ur third is add a entry in the client configuration to point to servername,portnumber with alais as ur servername then u can use ur servername itself to connect...
May 3, 2007 at 1:24 am
since thats database with a size of just 600MB i advise u to restore the database backup from tape to the local disk then try restoring the database from the...
May 3, 2007 at 1:10 am
case sensitivity depends on the server/database collation and it does not affect sql operators, statements and internal commands directly. it depends on your database and/or the server.
May 3, 2007 at 1:00 am
Does it happen regularly or rarely. if regularly use profiler to trace the sql performance and check for the root cause. if it occurs rarely monitor the performance of the...
May 3, 2007 at 12:56 am
just run this query
DBCC SQLPERF(logspace). This will return the size of the log file for the database and the percentage space effectively used. once u find that you can...
March 25, 2007 at 8:19 am
I hope u requirement can be met using CASE statement. try with tat.
March 25, 2007 at 8:16 am
Boss, You will get everything in Books Online.
March 22, 2007 at 8:14 am
What is the recovery model that is been set in that particular database?
March 22, 2007 at 8:10 am
Viewing 15 posts - 1,201 through 1,215 (of 1,335 total)