Viewing 15 posts - 5,551 through 5,565 (of 6,105 total)
If you are running a Profiler trace and have the Deadlocking events turned on, you can capture that sort of information. Also, if I remember right, the blocking scripts...
February 28, 2002 at 7:56 am
The rule of thumb is to use Windows authentication whenever possible. There are obviously exceptions, but it ensures that there is one user account, one password. There is...
February 27, 2002 at 9:37 am
You'll find, though, that the majority consensus is not to use 3rd party agents to do backups of SQL Server. Safer to do the backup to the file system...
February 26, 2002 at 7:52 pm
quote:
If you need to restart one of the instances of SQL Server
Which raises the question...
February 26, 2002 at 7:50 pm
quote:
You'd think the Sql server name could be resolved by broadcast alone.
Is WINS in the...
February 26, 2002 at 7:47 pm
It comes down to a measure of trust. Now, organizations that have 50-60 user accounts with Domain Admin rights immediately tend to raise flags from a security perspective, as...
February 26, 2002 at 7:42 pm
Using CASE in the ORDER BY clause it's possible to select the columns:
USE Northwind
GO
DECLARE @sort_column varchar(10)
DECLARE @order char(1)
SET @sort_column = 'CustomerID'
SET @order = 'A'
SELECT CustomerID, ContactName
FROM...
February 26, 2002 at 3:46 pm
Yes, a member of the local Administrators group could log in to SQL Server and change the settings back and forth between Windows authentication only or Mixed Mode (both Windows...
February 26, 2002 at 3:36 pm
You can use the rebuildm.exe command from the command line. Make sure you have a SQL Server CD. This will replace the master, model, and msdb databases (so...
February 26, 2002 at 12:15 pm
What version of the client tools (7 or 2000) and what service pack of SQL Server on the client side?
K. Brian Kelley
February 26, 2002 at 12:13 pm
It looks like you're probably going to have to upgrade to MDAC 2.6 or MDAC 2.7. The work arounds given by Microsoft are to use aliasing:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274383
Since you've got the...
February 26, 2002 at 9:04 am
What happens when you execute the stored procedure through Query Analyzer?
K. Brian Kelley
February 26, 2002 at 8:38 am
MDAC 2.6 and higher is required to access Virtual Instances without resorting to creating aliases or specifically configuring port configurations in the ODBC settings. MDAC 2.5 is what is...
February 26, 2002 at 8:35 am
A short list:
February 26, 2002 at 7:42 am
T-SQL is also the programming variant for Sybase, the DB Server from which Microsoft's SQL Server has its roots.
K. Brian Kelley
February 26, 2002 at 7:36 am
Viewing 15 posts - 5,551 through 5,565 (of 6,105 total)