One of the things that was expected in SQL Server 7 but didn't materialize is cascading referential integrity. It is present in SQL Server 2000.

In SQL Server...

It works, but you've got time to take the backup, time to do the copy, time to restore the database versus primarily time to do the copy.

K. Brian Kelley

bkelley@sqlservercentral.com

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

That's a bit different. Null is typically used to represent an unknown value. This is different from an empty value.

For instance, I have two friends, one...

One other thing you can do is turn on Profiler and see if the application sends a new query to SQL Server when F2 is pressed. That'll let you...

I haven't looked into it and it's another area I need to do more research. In my production environment where DBAs were allowed only in an advisory role, developers...

Just for the sake of overkill...

For each time you're making a new trip for say a stored procedure, it's not the data being transmitted that's the issue so much as...

Microsoft's support for multiple instances with going with dynamic memory is supposedly up to par. I've not had issues with it running SQL 7 Default and SQL 2K Named...

It indeed causes blocking on the stored procedure meaning it's a wait in line type of thing. Here's a quote from the Q article that made my eyes widen...

This looks like a brain dump question, so I'm going to play a little Devil's Advocate here. Can you go through each choice and indicate whether you think it...

I've not seen this error with the debugger, but I'll keep my eye out. You are in Query Analyzer at the workstation and not through a Terminal Services session...

Copy Database Wizard is, I believe, still using DTS. In any case, here's a previous discussion on the same issue:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=1707&FORUM_ID=5&CAT_ID=1&Topic_Title=How%20to%20move%20Database%20From%20SQL7%20to%20SQL2000&Forum_Title=Administration

K. Brian Kelley

bkelley@sqlservercentral.com

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

The SourceSafe method is how we compare differences. And unless I'm mistaken, I believe that is how SQL Compare works.

K. Brian Kelley

bkelley@sqlservercentral.com

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

Here's the allowed list:

• Assignment statements.
• Control-of-Flow statements.
• DECLARE statements defining data variables and cursors that are local to the function.
• SELECT statements containing select lists with expressions that assign values to variables that...

Transactional replication should work for you. It starts with a point in time snapshot from the live database to the standby database, and from then on you're only transmitting...

This is the one that gets me upset most of the time:

quote:

---

The only problem here can be third party software that utilises...