I have a login to my SQL Server 2005 database, and my database has a user of
the same name. I have linked the login to this user, and set the default
schema to be MySchema.
Then, I log in to SSMS as this login/user and execute a stored procedure

İs there a way to know when 'clr enabled' configuration is enabled or
disabled ?
Thanks
Hakan Fatih YILDIRIM

I thought this would be easy, but I should have learnt by now ...
If I have the code below, it returns a row, which is what I would expect for
my table.
   DECLARE @Filter varchar(MAX)

I have a stored procedure using dynamic sql.  It creates fine, but
when I run it I have an error for every GO in my @sql, which I
EXEC(@SQL) at the end of the procedure.
If I put a PRINT @SQL before the final EXEC() in my stored procedure

After searching and reading some quite amusing posts 9 years old, it
seems that 9 years later SQL Server still doesn't have any TIME
specific formatting options.
I need to compare datetime data down to the minute accuracy (but no

I'm running SQL Server 2000 right now.  I know I can use Enterprise
Manager to script them out, but I would like to automate the process
so I can keep track of the changes.  I looked into scptxfr but it
doesn't appear to generate a script for my jobs.  I also ran profiler

I am monitoring sql server and windows performance counters.
My computer has "Microsoft windows XP professional". I am monitoring sql
servers (2000 (sp3 and sp4) and 2005)  running on windows NT 4 and 5.2.    
For historical analysis I want to store the values of various counters ...

Can you simply use the following scripting to move the log files for
Reporting Services and the distmdl.ldf file to another drive (similar to the
scripts for the tempdb database)?:
USE master;

I have a SQL 2005 SP1 server running on one server and a SQL 2000 SP1 server
running on another.  I have created a Linked Server connections from the 2005
Server to the 2000 Server. When I run the following query I get the resultant
error.

I have a large query that gets pasted into an Excel sheet. The query
sorts the results by company name and then location (traditional stock-
keeping report). The user can then change various numbers in the
sheet, writing down stock for instance, and a series of formulas

I am using SQL Server 2005.
I have a login that is mapped to a user of the same name: MyUser. I also
have a schema MySchema.
I want to grant permissions on all objects in MySchema to MyUser, and at the

In SQL 2000, you could click on the properties of security and specify SQL
to run as a specific account.  Do you do this similarly in SQL 2005, simply
by opening the MSSQLSERVER servuce in the Services applet and put in the
username and password there?

I'm having to uninstall and reinstall SQL 2005 Standard Edition, as I was
unable to successfully move the system ldf files like I wanted after
installing the first time.  I'm gonna path these guys during the initial
install and hope for the best.

I'd like our DBA team to be able to fully manage SQL server but without the
need for Local Admin rights on the operating system. In theory I can grant
sysadmin role on the server, read/write access to the DATA, FTDATA and
BACKUP FileSystem locations etc. They need to be able to ...

I recently set up an SQL 2005 server with just one instance. I'm happy with
the performance of this new server during testing. It will run about 10
databases who's sizes are in the range of hundreds of tables with tens of
thousands of rows, with hundreds of users (in other words, ...