You're trying to write the trace file in the root of C:.

I remember that on a lot of server systems you need special permissions to create files there. Try using...

ahmad.ghazi (6/10/2009)

---

Dear All,

I have used to drop the replication configuration a stored procedure called sp_removedbreplication , But by mistake which is a big mistake, i have executed this procedure...

FreeHansje (6/11/2009)

---

'The only way to do this in SQL 2005 is by running a trace. '

I'm not sure, but I recall having read somewhere, that Profiler does not catch every...

Which method is best for you depends on the situation. There is not one option more preferable than the other. I suggest you read the document in this link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displaylang=en

It describes...

sharad.mail4 (6/11/2009)

---

Please help me As I have Installed Evaluation Period of SQL SERVER 2008 and I tried for table data type but the same is not reflecting under database Programmability.

Please...

Try this:

EXEC master.dbo.sp_addlinkedserver...

The only way to do this in SQL 2005 is by running a trace.

Triggers won't catch select statements.

NT AUTHORITY\SYSTEM is the local system account on the machine.

BUILTIN\Administrators is the local administrators group on the machine.

Usually this message comes up on x64 servers there the sql service account doesn't have the right to "Lock pages in memory" or especially on a x64 standard edition, because...

Grant Fritchey (6/10/2009)

---

Ok , that was odd. Again. The Thread is getting angry or something.

This was the response:

Really? So if someone posts some vague, random question the correct response is...

Grant Fritchey (6/10/2009)

---

I can't read minds, but I can see the future...

I see... I see... a dba-wanna-be on the street, looking for...

Any psychics around who can help this one

http://www.sqlservercentral.com/Forums/Topic732091-266-1.aspx

Do you really expect us to help you with this little information ???

Not sure if this is what you're loooking for, but microsoft has published some of the XML schemas used by SSIS, SSRS and other components.

http://schemas.microsoft.com/sqlserver/

Have a look at these two links. They show you different options on how you can achieve this.

http://www.sqlis.com/post/Easy-Package-Configuration.aspx

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx