What you mean no protocols if the Protocol NET Libraries are missing you'll have to reinstall to get them fixed.

To add an aliases do this:

1) Run SQL Server Configuration Manger.

2)...

Please don't cross post, replies here.

Thanks.

Try ...

SELECT TOP 50 qs.total_worker_time / execution_count as avg_worker_time,

(SELECT SUBSTRING(st.text,

...

I am taking a guess you meant 16774776 KB which is (~16GB).

So if you have 16GB, and you set SQL Server's max memory to 14,000MB (13.67GB); the rest of...

If you got the security settings already right only mistake I see is the quotes are in wrong place ...

Change

@query = 'xp_cmdshell type "P:\Userdb\Output\OD.out"'

to

@query = 'xp_cmdshell ''type P:\Userdb\Output\OD.out"'

Thanks.

IF OBJECT_ID('tempdb..#TT') <> 0

Drop Table #TT

Declare @CombinedValue varchar(255)

CREATE TABLE #TT (Col1 int, Col2 varchar(2))

Insert Into #TT Values (1,'1')

Insert Into #TT Values (1,'2')

Insert Into #TT...

Or timeouts from long waits. Please check Link; I posted a link there you use to check for blocking issues.

Thanks.

Thats Microsoft's party line, if it is not SP4 it is not supported. Because if you run into issues and you are not SP4 they can't say the issue was...

If you are having timeout because of blocking you can use the sp_blocker_pss80 (http://support.microsoft.com/kb/271509) here to try to find out what is causing the issue.

Be warned this produces a lot...

You have to use a proxy account when executing the xp_cmdshell extended stored procedure. Please look at http://www.databasejournal.com/features/mssql/article.php/3789881/Proxy-Accounts-in-SQL-Server.htm.

Thanks :).

Mohit.

Yes it is not "advised" as means to permanent solution to avoid updating/fixing your code. Compatibility mode was designed so your upgrade processes becomes less painful. "Use sp_dbcmptlevel...

I don't believe LIKE and CHARINDEX will use the FULL TEXT Index; the keywords to use a FULL TEXT index are, contains, containstable, freetext, and freetexttable.

Thanks.

Mohit.

This article (http://support.microsoft.com/default.aspx/kb/910230) is showing you how to do it using GUI not command line. HTA is a HTML file that can be executed; thats all. After you...

Possible using http://www.sqlservercentral.com/articles/SQLServerCentral/sqlserver2005logontriggers/2366/ article (very good article)

4. Exixtence of users or...

I see if you need such detail I would recommend looking at RedGate...