ran dbcc checkdb and got 1 consistency error on a tbale.  But I am unable to
find which table and not sure what to do.  Not sure what I should do so any
directions with this would be much apperciated
Table error: Object ID 0, index ID 0, page ID (1:1880507). The PageId in the

Why is it not possible to construct two or more primary indexes or table
clusters for a table?

I can't create a datasource link from Visio
Professional tp SQL Server installed on my machine.  I installed the
Server with
default configuration and windows authentication.  I can't get all the

We recently migrated to SQL 2005, and we are running xp_cmdshell calls at
through our proxy account, which works fine the majority of the time.
However... occasionally xp_cmdshells will start to fail, and do not begin
working again until the cluster is failed over.  (of course I ...

Using Reporting services just wondering if with intergrated mode i
should be able to connect to the site without a user and pass being
requested? also should i be using NTLM or Kerberos auth?

Client updating all rows in a huge table (about 17M rows) and the commit
seems to be taking forever. Is there a way of telling how far along the
commit is in SQL 2000?  Thanks.

I want to export SQL Server data to any of the plain file formats. For this
purpose here are the methods I tried:
[1] bcp.exe is the worst and (unfortunately) the fastest data export tool
for MSSQL I know of. Because of it doesn't escape delimiter characters found

I'm  trying to convert MySQL db to SQL Server.  I have the datatypes
converted.  Query Analyzer gets stuck on
the "UNIQUE KEY",
"KEY" words in MySQL..  I tried changing the "UNIQUE KEY" or "KEY"  to

In an earlier post, I asked about collation when moving databases from
SQL2000 to 2005 (I've also read the post from Steve Z above). Thanks for
John Bell for the help.
I now have more specific details of the exact instance and DB collations I'm

I manually created the 'distributor_admin' remote login and gave it
the 'sa' password.  When I try to setup replication I get error 18456
'Login failed for 'distributor_admin'.
I am assuming that the password for the 'distributor_admin' login is

I am attempting to transfer a SQL 2000 database to SQL 2005. It is a
Project Server database. My SQL 2005 installation is on a different
server. I've tried detach/attach, copy, export/import, backup/restore.
I keep getting the same error, "There is already an object named

I got the database created in Object Explorer window.   All I need is
a connection.  I can't create a local datasource from Visio
Professional.  The driver is Sql Server.  I installed the Server with
default configuration and windows authentication.  It can't create a

I am writing a simple stored proc:
creat PROCEDURE Purge
@timet numeric(3) -- User Specifies how much data to perserve in
months

We are using Sqlserver 2005  EE.  
Our production server instance keeps locking down and I found the
LazyWriter: warning, no free buffers found in the log everytime.  
During the locking down, no connection can be made , the existing session

i became a bit confused with a length of data stored in varchar datatype.
When ansi_padding is on (which is default), column is padded with trailing
spaces - BOL. However, datalength() function does not show it.
And if that's true (padding with spaces), it makes it equivalent to ...