Viewing 15 posts - 331 through 345 (of 502 total)
CirquedeSQLeil (8/25/2009)
There can be many times where a 30-40 hour day are necessary to get the job done.
I have yet to work a 30-40 hour day 🙂 but regularly...
August 26, 2009 at 4:22 pm
It sound like you may have some script tasks which are not precompiled. On the script properties set "PrecompileScriptIntoBinaryCode" to true.
August 17, 2009 at 4:10 pm
When I applied SP3 to my 2005 mirrored servers this is the process I followed:
1. Pause mirroring
2. Apply SP3 to the witness server
3. Apply SP3 to the mirror server
4....
August 12, 2009 at 4:51 pm
Try shrinking in smaller increments. It's going to take a while (hours) to shrink a data file while the data pages are moved.
When using DBCC SHRINKFILE( 1, 200 ); It...
August 12, 2009 at 4:32 pm
You might try dumping to flat files, zipping them, copying them to the DW server, unzipping, and then importing.
August 10, 2009 at 3:40 pm
In SQL 2005 using SSMS you can right click a table and select "Open Table".
August 10, 2009 at 3:36 pm
I agree with Gail, wait. It's going to rollback one way or another. If you restart SQL Server the rollback process starts under a system SPID and you can't use...
August 5, 2009 at 4:09 pm
This should get you started.
http://msdn.microsoft.com/en-us/library/ms151198(SQL.90).aspx
July 31, 2009 at 3:40 pm
Cumulative update 4 for SQL 2005 SP3 is available and you only have to apply the latest cumulative update to receive the fixes from the previous CU's.
http://support.microsoft.com/kb/970279
The cumulative updates for...
July 31, 2009 at 3:31 pm
Sounds like the downloaded MSI got corrupted. I would delete it and try re-downloading BOL.
July 29, 2009 at 4:22 pm
If the database is in Full recovery:
After a tran log backup,
ALTER DATABASE [DATABASENAME]
REMOVE FILE [SECONDARYLOGFILENAME]
If the database is in Simple recovery:
Issue a CHECKPOINT
ALTER DATABASE [DATABASENAME]
REMOVE FILE [SECONDARYLOGFILENAME]
July 22, 2009 at 4:28 pm
You can connect if you use the RS URL to connect. When using SSMS 2008 to connect to SSRS 2005, use http://servername/reportserver in the Server name.
July 16, 2009 at 5:29 pm
I'm not sure if you can find who installed SQL originally but you can find out who applied Service Pack 4 by checking the InstalledBy entry in the following registry...
June 26, 2009 at 3:58 pm
Talk with your SAN administrator. He/she should have some monitoring tools for the SAN.
June 4, 2009 at 5:07 pm
Viewing 15 posts - 331 through 345 (of 502 total)