Hey Folks,
According to the documentation (BOL), the best way to remove inconsistencies
in a database that fails dbbcc checkdb is to do a restore. I did this and the
inconsistency still exists (CHECKDB found 0 allocation errors and 1

I'm wondering if there's a means to execute a stored prodecure (or perhaps a
single SQL statement) whenever an error is raised (whether manually using
RAISERROR or automatically from SQL Server) for means of logging. For
example, I'd like to fill a table with all raised errors, ...

We've got a Primary and Secondary Server (as a standby currently in Read
Only mode ) on a Log Shipping set up.
For the last week the TRN files have been backed up and moved across to the
Secondary Server - but I've discovered they haven't been restoring.

I am experiencing a problem with SQL Express (VS 2005) (mdf file) and
IIS 6 deployment issue. There is an application that is developed by
me on ASP.NET C# and needs to be deployed on IIS 6 server.
The application:

I am using Sql Server 2005 and found a problem with importing csv files that
I don't believe happened in 2000.
If I am importing a .csv file, it will assume that I want to output char(50)
for every single field.

q) I want all access availabe to role EveryoneRole to
PublicReaderRole. Is this correct?
grant control on role::EveryoneRole to PublicReaderRole
q) I want to give access of role to user. Is this correct?

I have a production sql box  (SQL Server 2005 SP2 and  Windows Server 2003
64bit) that is heavily fragmented. This is the result from the built in
defrag.exe.
To defrag a machine like this, you have published some best practices,

It seems that SQL Server does not permit a restore from a non-local drive
(dataset).  Does anyone have a technique to accomplish a restore from a
non-local drive?
Thank you,

Dear reader
Our database is rolled out to several locations. Normally because of the
default and some specified typing, all text fields (varchar etc.) are
created as SQL_Latin1_General_CP1_CI_AS.

What is the maximum memory limit for SQL2000 SP4 (32-bit) running on Win2003
Standard Server (64-bit)?  I take it that we cannot enable AWE since the OS
is 64 bit.
Thanks,

I'm receiving this error. Is this due to memory?
Err No: 17 :[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
or access denied.;
It happens if the loop gets larger than a certain number of loop iterations.

i got the following error while trying to connect to localhost:
A connection was successfully established with the server, but then an error
occurred during the login process. (provider: Shared Memory Provider, error:
0 - No process is on the other end of the pipe.)

I have a table that has about 100 columns in it, filled with
expensively calculated numbers. I'd like to display these along with
subtotals for each "program" and "group" (inventory areas). I would
have thought that ROLLUP would be the right solution for this, but

First of all, my apologies for doing a re-post, but I didn't get a response
from the ODBC section....  So here it is again.....
Hello,
I am receiving the following error when sending a paramaterized statement

I need to keep track of user/program update sql table.
I created a trigger for the update user filed by
update instacontrol set  username  = system_user where intmid = (select
intmid from inserted)