Viewing 15 posts - 466 through 480 (of 1,166 total)
January 24, 2007 at 11:31 pm
Try disabling the Enforce password policy...
Security/Logins/sa/Properties/unchecked: Enforce password policy.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=306429&SiteID=1
January 24, 2007 at 11:18 pm
SQL gets time from OS, as long as your OS is patched SQL should be fine...
January 24, 2007 at 6:30 pm
I don't think there is any size setting in dts and limitation of the file size...
I have uploaded the data from >100 MB files many time...
Try to log to dts...
January 24, 2007 at 6:25 pm
I don't have step by step guide to give you but the following article is for sql 2000...you follow the instructions in SSMS instead of EM and check "Figure 29"...
January 24, 2007 at 6:15 pm
Check if the contrainsts and ranges are correct through SSMS on both servers..
January 24, 2007 at 6:08 pm
If you are restoring through EM/QA cancell the restore or
run SP_WHO2 ACTIVE and get the SPID for the restore process then kill the SPID using KILL <SPID> command...
January 24, 2007 at 5:59 pm
I think there is nay SQL Server 2005 Embedded Edition...where as there is Express Edition...
SQL Server 2005 Features Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
January 24, 2007 at 5:52 pm
Create full backup, incremental backup (differential backup) and tlog backup job on your machine and script them send the code to the person who has the access to creat the...
January 24, 2007 at 5:47 pm
From BOL:
Subscribers must synchronize with the Publisher to receive new ranges. Because Subscribers are assigned identity ranges automatically, it is possible for any Subscriber to exhaust the entire supply of...
January 23, 2007 at 11:23 pm
It is good idea to keep your backups safe...
Backup/Restore might be slow becuase you have use backup files from 3rd server...but speed is depends on your network...and server NIC configuration...
January 23, 2007 at 11:09 pm
Please post this RS group so that you get immediate answer...
January 23, 2007 at 11:06 pm
Client can be convinced because dbo right be given in tempdb not in user database..
January 23, 2007 at 11:03 pm
http://msdn2.microsoft.com/en-US/library/ms143506.aspx
January 23, 2007 at 10:57 pm
Viewing 15 posts - 466 through 480 (of 1,166 total)