Check Authentication that is been used for Linked Servers

Hi Marmot

This looks good for me, saying that it depends upon what the company really needs,...

Are you having any files that are from 29th, check the time that you specify for deletion 🙂

Well you can see the same on 2008 as well, Activity Monitor, this has got many more features than 2000 🙂

Hmm nice one, I can roughly calculate the Configuration, but i would look into various other factors as well , It will be interested to know if there are formulas...

Hi Eswin

I had inserted all the table names into a table with an Identity insert ID, i got 371...

Brilliant Eswin, Thanks a lot mate, i wrote a script on a while loop to find out the tables. 🙂

Hi Venki

It depends for what you are going to use SQL server for, Enerprise Edition is free (...

SSIS will do, but when you say that the tables havent got a Primary key it will be process intensive to get the last 2 hours of data and transfer...

Can you provide with the information that you currently hold, some one might have experienced the same problem in earlier stages and might have a solution 🙂

Ops that's my mistake, It worked, Thanks a LOT 😀

DAtabase1 is the database Name, so that cant be changed:-)

Hmm not sure about U-Tube, but you can store images and videos on SQL using Varbinary datatype and if you are using 2008 you can use streaming 🙂

Hi Chris , thanks for the reply

Msg 1098, Level 15, State 1, Procedure ddltrg_CREATE_TABLE_LOG, Line 28

The specified event type(s) is/are not valid on the specified target object.

This is the message...

Thanks Mate 🙂