Andy is correct. It stores diagrams. MS recently turned the XTYPE to "U" in a late SQL 7 service pack so you could transfer them from server to...

If you're going to cluster using Active/Active, then the client will need to have MDAC 2.6 to access the second node (named instance support didn't exist until MDAC 2.6). ...

The xp_fixeddrives will only show you the free space in MB. I'm afraid it can't help output the percentage. I like the FileSystemObject idea or especially the srvinfo...

If your backup in this scenario completed at 2:42AM, then it would not capture events that committed after the backup completed. So if your huge transaction comitted during the...

The backup completes and the backs up any items it missed during the backup. So, your users transaction would be caught by the backup net.

Brian...

You'll have to build the string dynamically and then execute it as one variable.

Here's a simplified version:

SET @VAREXEC = 'SELECT blah, blah, blah from '+ @TblProfessione + 'WHERE ID =...

Unlike other DBMS's SQL Server cannot do this through DRI. To enforce this type of RI, you will have to use triggers.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

I'm running SQL 2K and 7.0 in both environments and have not noticed any performance enhancement/degregation between the two. We had a *slight* performance enhancement when going to Win2K...

Thanks Wes! I'd love to see the product. Could you post the URL? Free is always good!

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

quote:

---

whats DB2 like? I've never messed with it before.

---

I've got to agree with MarkSopczak on...

In a cluster, the binaries have to go on the local drive. Even when not in a cluster, I would place the binaries on the local drive. Then,...

Essentially it is the same as going between a stand-alone server but instead of the real server name, you'd use the virtual server name.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

Try to run this query to see if you see the same results. This will show you what SQL Server thinks it has in the tables:

select substring(o.name, 1, 30)...

Here's a full explaination:

http://www.sqlservercentral.com/columnists/bknight/renameserver.asp

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

I pull the same load that Steve does. I do also support a little of the NT env. as well. My real task though is just to wax...