Viewing 15 posts - 5,791 through 5,805 (of 6,105 total)
The triggers/constraints issue in SQL Server 7 meant that I had to manually delete from the bottom up with respect to a SQL 7 database I designed. It wasn't...
January 28, 2002 at 5:02 pm
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...
January 28, 2002 at 4:04 pm
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
January 28, 2002 at 3:51 pm
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...
January 28, 2002 at 1:52 pm
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...
January 28, 2002 at 1:41 pm
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...
January 28, 2002 at 1:40 pm
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...
January 28, 2002 at 1:36 pm
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...
January 28, 2002 at 1:23 pm
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...
January 28, 2002 at 1:17 pm
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...
January 28, 2002 at 10:06 am
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...
January 28, 2002 at 10:02 am
Copy Database Wizard is, I believe, still using DTS. In any case, here's a previous discussion on the same issue:
K. Brian Kelley
January 28, 2002 at 9:56 am
The SourceSafe method is how we compare differences. And unless I'm mistaken, I believe that is how SQL Compare works.
K. Brian Kelley
January 28, 2002 at 9:52 am
Here's the allowed list:
January 28, 2002 at 7:16 am
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...
January 27, 2002 at 9:24 pm
Viewing 15 posts - 5,791 through 5,805 (of 6,105 total)