wannabe dba (4/28/2009)

---

I have created a procedure which will create backups of all the databases on the server for a SQL SERVER express instance when called from OSQL.Here is the...

is it instant? or is it several minutes later that the related data is removed

just thinking you might have a sql server agent job that purges related data

it can only...

if you set up a profiler trace then you should be able to capture this

just remember to set "RPC/statement/batch starting" and RPC complete events in the trace - if you...

another thought - although i may be barking up the wrong tree here..

how does SQL 2005/2008 know if there has never been a backup? if it's the MSDB backup history...

also before you run these tests make sure you clear the buffer cache and make sure they are both compiled - otherwise you will skew your results

I've experienced similar - i think this is to do with your UDF

try creating a temp table (for test purposes) and insert into the test table the data returned from...

well - I kind of agree, but it's a difficult call.

this is not a "coding" role - where you get to create new features, but a "consultancy" or "advisory" role...

usefull info steve.. thanks

One more thing to add to the conversation

I'd love to call them "DBA" - however this is for one of our foreign offices (india) and i'm informed that the...

sumanta.roy52 (4/9/2009)

---

Hi Michel..Thanks for your information.... I want to know more about it. Say, I have one application which is using SQL server and it has multiple instances. Can the...

An instance is an installation of SQL server.

you can have many instances on one server.

Each instance will have a set of system databases and it's own configuration.

Each instance can...

if you can risk gost data in your select statement then you could change the code to use NOLOCK

Select * from table WITH (NOLOCK)

there are certain risks involved (possible...

nice try -

unfortunatly the output of a proc can be anyting and is not stored in syscomments or syscolumns....

i went that way to start with ..... i think this...

bank holidays and non working days functions

PCI compliance for credit and bank data out of the box