Viewing 14 posts - 271 through 285 (of 285 total)
I can see Andy’s points about the advantages of using stored procedures, but I guess I'm swimming up stream here... I’m not trying to start a flame war, but there...
April 22, 2003 at 6:33 am
quote:
After the installation of SP3, I've noticed this error on two servers:2003-03-21 09:59:12.07 server Error: 17883, Severity: 1, State: 0
2003-03-21 09:59:12.07 server...
March 26, 2003 at 6:50 am
After the installation of SP3, I've noticed this error on two servers:
2003-03-21 09:59:12.07 server Error: 17883, Severity: 1, State: 0
2003-03-21 09:59:12.07 server The Scheduler...
March 21, 2003 at 9:51 am
quote:
Where MSDE can be especially dangerous is when a user takes their laptop home with MSDE on it, becomes infected with any...
February 6, 2003 at 9:56 am
Quote from firthr:
"It seems MDAC 2.6 and under can't authenticate to even start the install."
I ran into this (i.e., SP3 would not authenticate via Windows authentication or via the sa...
February 5, 2003 at 7:07 am
quote:
Yes and no. I used a third party tool for developing some T-SQL that claimed VSS integration. I could not get it...
January 3, 2003 at 7:11 am
quote:
Have you considered a database in Standby mode ? This allows read-only access. Read "Using Standby Servers" in BOL.
January 3, 2003 at 6:25 am
>>However, it should be relatively simple as a physical level optimization to partition the relevant table into two tables, one containing the non-BLOB data and another containing the BLOB data.
Actually,...
January 2, 2003 at 12:53 pm
Transaction logging of BLOBs was a problem for us, especially under SQL 6.5. On a change to the supporting database row, 6.5 appeared to log the entire BLOB (as well...
January 2, 2003 at 7:57 am
quote:
If you have three systems, for example, a devel server, test server and Production server, then make the ids start at 1...
December 16, 2002 at 8:35 am
I found a reference to "Scripting XML and WMI for Microsoft(r) SQL Server 2000: Professional Developer's Guide":
Does anyone know if this book would be a good resource for someone competent...
December 4, 2002 at 6:40 am
I saw this reference about DMO being phased out:
December 4, 2002 at 6:00 am
I ran Profiler on the server before making my original post. I was surprised by the number of statements that Enterprise Manager executes for a single new linked server. I...
December 3, 2002 at 2:29 pm
I tested this a while back at our site. Here are my notes.
To restore the master database from a SQL Server backup:
- Stop SQL Server:
- Open...
December 3, 2002 at 2:26 pm
Viewing 14 posts - 271 through 285 (of 285 total)