1. What is the output of

SELECT

* FROM msdb.dbo.syssubsystems where subsystem...

1000+ issues

Noel,

Online index operations are available only in SQL Server 2005 Enterprise Edition.

Nothing strange in it.

If you use SQL Native Client, this message is common. I guess you are confused with "SQL 2005" in error message. 

Please check SQL Error Logs and make...

Why there is filter for session_id > 50?

SQL Server 2005 does not have same mechanism as SQL 2000 where system SPID are always less than 50.

1. What is structure of Test1 table?

2. Can you provide sample data (1 or 2 rows) from test.dat file?

3. SQL 2000/SQL 2005?

4. Can you check SQL ERRORLOG (C:\Program Files\Microsoft SQL...

You cannot store two rows in same cell. Bad workaround would be to use comma or other seperator to seperate them. But this is BAD design of RDBMS. Moreover you...

Without triggers it is not very easy. Triggers can meet your exact requirement.

As you mentioned you can use Profiler tool which is UI based Tool but again you cannot query...

Wanderer is correct. There is no new parameter with sp_send_dbmail, its in-built now.

921896 A list of the bugs that are fixed in SQL Server 2005 Service Pack 2

http://support.microsoft.com/default.aspx?scid=kb;EN-US;921896

Above refered to KB...

Contact me at IM bmlakhani@yahoo.com

In order for it to work with Windows Authentication on remote machine you need to turn on “Security Account Delegation”

Security Account Delegation

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2gmm.asp

OR

Use SQL Server Authentication

This is by Design and is documented very clearly on Books online.

BULK INSERT <http://msdn2.microsoft.com/en-us/library/ms188365.aspx>

Security Account Delegation (Impersonation)

If a SQL Server user is logged in using Windows Authentication, the user...

When you see "hang" did you check using profiler about what is happening on SQL Server side.

Can you create stored procedure using "WITH RECOMPILE" clause and let me know...

There is nothing different between 2000 and 2005.

The problem wihch you are facing sounds familar (i have done many backup and restores). I think your user in db is not...

Franc,

Since msdb database is corrupt (we would like to know error message to confirm this) follow below steps.

1. Backup all databases (except msdb)

2. rebuild system databases as indicated by deepak

3....