The error message highlights 'Activation context generation failed'. Please check ACLs for the account that you use for Updates.

I didn't check the character position but based on you comment, it should appear in this...

Please check your Server’s collation.

SQL Server Collation Fundamentals

http://msdn.microsoft.com/en-us/library/aa174903(v=SQL.80).aspx

madeeha.rehman5 (11/26/2011)

---

i m not asking in procedures.

if i use this i dnt help me

declare @val varchar(200);

set @val=''; -- Write a valid SQL here.

exec (@Val)

but b/w this if i want to...

Use of xp_cmdshell could be very risky. Please don't forget to read following before you decide on it.

I cringe every time I see a recommendation for xp_cmdshell.

http://www.sqlservercentral.com/Forums/FindPost1186236.aspx

We received a similar case few days back in SSC. Faulty Logins were the issue. Can you please verify the Logins you are using didn’t change their password recently? Also...

Only one question. Why???

jewel.sacred (11/28/2011)

---

I think it is not OK (not always atleast). Imagine the hard disk gets full...

I usually avoid the discussions when it turns to DBA Vs DEV (developers, not me ;-)). I do understand DBAs are last line of defence but why do we forget...

It's OK Aaron. 2 Backups are better than 1 (or none) 😉

@RuanK: You probably have misunderstanding on 'Working with Oracle' section. We discuss Oracle issues here if they are related to SQL Server as well e.g. Linked Server. We don't discuss...

It’s a Performance Issue and I am not sure why nobody requested for DDLs & scripts with execution plans.

@znkin: All the suggestions from SSC are good (but valid for some...

Replication Monitor would be a good start.

Monitoring How-to Topics (Replication)

http://msdn.microsoft.com/en-us/library/ms151758.aspx

1) Create a View with editor.

2) Copy the View's SQL query.

3) Drop the View.

Use Dynamic SQL by splitting the copied view query into proper sections.

SET strQuery=strSel + strFrm + strWhr...

@fracionero (11/26/2011)

---

I have an application that detects the datatype of a table column, in SQL 2000 it detects datetime, but in sql 2008 R2, detects datetime2(0), and when uses that...