Viewing 15 posts - 751 through 765 (of 1,155 total)
What edition of SQL Server are you using ? And 32 bit or 64 bit ?
What Version & edition of Windows are you using ? And 32 bit or 64...
December 14, 2010 at 1:47 pm
To prevent this from happening, change the growth size to unrestricted. If you set the Growth size to restricted, then you need to monitor the log size growth continously...
December 14, 2010 at 11:59 am
Follow Pradeep's advice. Check if you have any offline Full text Catalogs and drop them if they are no longer used or rebuild them if they are needed and then...
December 14, 2010 at 11:34 am
If you need to make the data synchronization from the publisher to subscriber on a regular basis , then you need to schedule the snapshot replication. Generate Snapshot immediately is...
December 14, 2010 at 11:22 am
MS removed the dependency of SSRS on IIS , starting with SQL Server 2008.
...
December 14, 2010 at 11:02 am
Bjhogan is right. It think this has something to do with the datatype conversions like smalldatetime and datetime conversions and some times could be due to entering NULL values for...
December 14, 2010 at 10:59 am
This happens if your job has multiple steps say Step1 and Step2.
For each step, you need to specify the SQL Server agent what to do in case of success or...
December 14, 2010 at 10:49 am
The DTS packages are stored in the msdb.dbo.sysdtspackages table on a SQL Server 2000 instance. So a simple backup and restore should get all your DTS Packages. Or you...
December 14, 2010 at 10:19 am
If you are using Maintenance Plan to take the backups, then the combination of the Maintenance Plan logs and Application log should help you to find the root cause of...
December 13, 2010 at 1:10 pm
Setting Max Memory doesn't need restart.
Thank You,
Best Regards,
SQLBuddy
December 13, 2010 at 11:45 am
Pls post the error message.
Thank You,
Best Regards,
SQLBuddy
December 13, 2010 at 11:24 am
Hi David,
Uisng Export\Import Wizard, creates an SSIS package. As it was created for the Dev box, it...
December 11, 2010 at 5:46 pm
I have been using MPs for many years, even on SQL Server 2008 R2. If there were any issues, that were due to things external to the MPs. Just like...
December 11, 2010 at 5:27 pm
As Mike said, Set Max Mem = 3GB = 3072 MB.
Also assign Lock pages in memory privilege to SQL Server and increase the page file size to 8-10GB.
...
December 11, 2010 at 5:20 pm
Follow Grant's advice. He is right there.
Thank You,
Best Regards,
SQLBuddy
December 11, 2010 at 5:16 pm
Viewing 15 posts - 751 through 765 (of 1,155 total)