In the C# code below, I'm having trouble when I try to use a bind variable
for the column name in an update command.  The example below works fine when
I use the first sqlstr spelling out the column name.  When I try to use the
second sqlstr using @columnName I get an error ...

Hi I have a stored procedure that inserted data into a database and also
inserts a due date.  I need the query to set the due date as follows;
If the 5th day of the month falls on a saturday I want to set the due date
to the friday prior (4th), if the 5th falls on a sunday I want ...

We have a server with some 100 sql 2000 Databases.
How can I tell the last time a database was updated? accessed?
Will the mod date on the data file be a clue? how about the mod date
on the log file?

When I run the check database command, I get this error:
error -2147212552: Table error: database 'rivers', index
'timecard.IX_cashier'(ID 1237579447)(index ID 2). extra or invalid key for
the keys:

Calling all MVPs,
I am seeing this error on a new server build.
A significant part of sql server process memory has been paged out. This may
result in a performance degradation. Duration: 0 seconds. Working set (KB):

Our company is expanding into Europe and we need to get some sample
databases so we can learn the input methods.
We mainly need to learn how European addresses and Telephone numbers are
formatted?  We will be storing the following in a MS-Access / SQL server

Hi experts,
I have run a sql in SQL Server 2005. I run this sql very fast (about 1~3
seconds) in other db servers, but in one db server, it runs very slow, even
it cannot complete in 15 minutes.

OK I have a weird problem happening.....
I have a stored proc that will not run in 13 hrs.  If I pull the select
statement out (that is all that is in the proc) and run it as an Ad Hoc query
it completes in 4 secs.  

Because of SOX, I need a tool to monitor database users logon/logoff, data
changes so on. If I use sql profiler, it will create too much overhead to the
server. Is there any third party tool that anyone knows is good?
Thanks a lot,

How do I link the orphane user if it is a windows login like domain\user?
sp_change_users_login 'update_one', 'domain\user','domain\user'
it doesn't work, saying domain\user doesn't exist...
Thanks

Hi and thanks in advance for any replies.  I have a database made up of 6
files (Mdf & Ndf).  I unfortunately allowed the main MDF file to expand and
didn't allow the other 5 files to autogrow.  I now have a huge MDF file.  Is
there a way I can resize the database to redistribute ...

I am looking at setting up a fail-over (active-passive) clustered
environment based on SQL Server 2005 and Win2003 Ent 64 bit.
My understanding was always that we need only 1 SQL Server license (for the
active node). However my customer pointed out a paragraph in the Microsoft

I'm wondering if the bug has been fixed in SQL 2008. This is a bug regarding
a much slower operation with stored procedures using cursors.
Thanks,
KK

Currently am in process of planning out a migration from SQL 2000 to SQL 2005
using the side by side approach.
What I'm curious to know is has anyone been able to script out SQL 2000
linked server objects complete witht their ID's and passwords for inclusion

What is the best way to create a backup of an SQL 2005 database on my
hosting server?
A side question:
I have an SQL database with 4 tables.