Is there a way to query any dynamic view or system table to see if a
database has log shipping enabled? I belived it should be in
databaseproperty or databasepropertyex but I can'tr find it.
My purpose is to handle these databases in a different way when

I have a T-SQL query that runs a number of operations and then prints how
long it took from start to finish (see below). But I had to comment out all
the "Go" statements before I could use the variables for the starting and
ending times. The reason is that all @variables have to ...

I would like to know if there is some reason not to use this method
for looping.
Also, do you believe this code could be faster than the traditionnal
FETCH CURSOR?

How can I change the owner of a table on sql server 2000 with sql
enterprise manager?
Thank you
Sergio

We have run into a serious problem that we cannot solve.
We have a w2K3 SP2 server with sql2000 SP4+hotfix 2187 running on vmware esx
3.5. After migrating the server from one host to anothter (have done this
many times). The CPU went to 100% load on the sqlservr.exe process - even ...

I'd appriciate it if someone can point me to a web-site where I can get
information related to the working of the Transaction log.
Am looking for info on:
To start with I would say that the TL's size is to be x mb and then it has

I am trying to install Sql Server 2005 to my Laptop and it seems to install
but it can't start the service.
The 2 logs (Summary.txt and SQLSetup0006_CATH-SATELLITE_SQL.log) are as
follows:

restore failed for server
system.data.sqlclient.sqlerror the tail of the log for the database has not
been backed up. use backup log with no recovery to backup the log if it
contains work you do not want to lose. use the with replace or with stopat

I have tried to upgrade my SQL Server 2005 to Service Pack 2 with all
additional hotfixes.
I am unable to run Maintenance Plans, they error with syntax error, even
though they are wizard generated.

When I run the 2003 server compatibility report on my W2K server running SQL
2000 the report is showing SQL server 6.5. Yet when I ran select @@version
in Query Analyzer it is showing SQL 2000. I don't feel comfortable upgrading
the server OS to 2003 until I find out why my SQL ...

Hi Sql Server Expert,
it is set  to 2147483647 as default.
Is this really in MB?
Ping

I've developed a VB script to change the SQL service accounts for SQL 2005
servers using the WMI SetServiceAccount method.  The script runs fine on
stand-alone servers (with or without named instances), and it runs fine on
clusters as well, as long as I'm logged onto one of the ...

I'm having the following problem on SQLServer 2000:
we have a server where we have consolidated multiple applications.
Now we have applications complaining that there is not enough tempdb
datafile space free.

My issue is this :
1. SQL Server 2000 running on Windows 2003.
2. The extended stored proc xp_smtp_sendmail duly installed with grant to
Public.

I'd like to move the default location of the SQL Server error logs.  What
T-SQL or similar would allow me to modify this?  Current path is C:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG.
Thanks,