Hi All,

Thanks for your help.

Cheers,

A.

MCDBA training...

http://www.microsoft.com/learning/mcp/mcdba/

Rgds

A.

Truly said. The create statement run within a few milliseconds but the dropping of the global tables takes a lot of time. (If you uncomment the line with the drop...

Hi Ramesh,

Thank you.

I am just curious here. Is there any sql statement which can provide me same info for DTS packages. That is the db name for a given...

Ok.

My requirement is as follows: for each sql jobs that is scheduled on the sql server, i need to know against which database the job is scheduled.

I have 100 sql...

Hello,

I dnt know if the following existing.. just curious.. is there any dbcc checkdb with no_data_loss....

Thanks

A.

Hi Gila,

I ran the command and got the following outcome.

Msg 8928, Level 16, State 1, Line 1

Object ID 938486422, index ID 1, partition ID 342979622862848, alloc unit ID 61504646152192 (type...

Hi Ramesh,

Thanks for the reply.

Does this apply for MS 2000.

Thanks

A.

To put it simple, i have a table of 2million rows and i want to partition that. The database already have 2 filegroups to use. Can you please help me...

Yes you are right.

I am trying to move to different filegroups based on the partition key.

Thanks

A.

Hi Sergiy,

That's a nice one... but the company wnt accept that idea.. really unfortunate... 😀

Hi All,

Thanks for your replies. I got the idea.

Cheers

A.

Hi All,

Thanks for yours replies..

I am still struggling with this.. I tried the Software DTS Package Search. It does give the database name but still it is a manual task...

With reference to SSCrazy,

I have got a table which stores the information about the DTS in the msdb database. Below is the query:

select * from sysdtspackages

However, i dnt know whether...

Hi Sergiy,

I may be wrong, but I thought that this meta data information is stored somewhere (in some system database or files)...

Thanks

A