I have scripted the trace I have created. But when i try to run the script I am getting this error:

Windows error occurred while running SP_TRACE_CREATE. Error = 0x80070003(The system...

I am sorry I can start a new thread.

To answer your question:

Yes, I have started and stopped the profiler trace before scripting it.

Sounds easy.

But i was unable to script it.

I went to file menu and then opened file and went to script file.

It is not working.

It worked.

1.Go to Folder Settings.

2.Add New Role and give Content Manager role.

Thank You opc.three .

Your expression worked like charm.

I am sorry for not being clear .

This what i did:

1.Right click on the package and clicked variables.

2.to the left of a package you will see variables

3.i have added...

I found the error when i ran ssis package on the server (our server) .

The error says we cannot create the file if the file already exists on the destination...

I did table lock on my database and saw couple of errors for the table named 'temp_shipbad' so i did a restore everything works fine now.

I have scheduled these DBCC...

I ran dbcc check with estimateonly and i got:

Estimates tempdb space needed for CHECKALLOC(KB):

2182

Estimates tempdb space needed for CHECKTABLES(KB):

224267

Now i will i know the tempdb space of the database...

Yes we do have reporting services and reporting database that support ssrs .

i am sorry i didnot notice that There is one dependent foreign key constraint to the ABC table ID column.But i have dropped that too while deleting the rows the...

I have changed the datasource and it worked,but the problem i am having right now is different.

I have scheduled and subscribed the report to send me a mail and...

I have changed the server in data source in report manager and BIDS and it worked .

now i want to schedule this report and send mail .

is it possible using...

Perry Whittle (11/15/2010)

---

BIDS executes under your windows user account so that will be golden 😉

Edit the data source properties in SSRS to execute in your preferred fashion (windows account, sql...

Its my mistake the data source name in the server is not matching to the datasource in the BIDS ,so i have changed the data source name .

But i got...