select u.name

from sysprotects p

inner join sysobjects o

on o.id = p.id

inner join sysusers u

on p.uid = u.uid

where p.action = 196

and o.name = 'table_name'

No help.

Incremental Backup -...

Google tells you what you want:

Types of Backup in Windows:

http://technet.microsoft.com/en-us/library/cc784306.aspx

Here is SQL2K BOL: --- (4 types of backup)

http://technet.microsoft.com/en-us/library/aa174477(SQL.80).aspx

I skipped SQL2K5 (you can find it by yourself). Please tell me which...

SQL SERVER does not have incremental backup.

But, the Windows OS does have.;)

As Sakthi mentioned, you should use server name, not the database name, as the data source.

Actually, I didn't know the "UNIT" of R/W in profiler. But, when I thought about STATISTICS_IO, I picked up the correct answer.;)

You can update the uid of systypes table.

BUT, THIS IS A BAD PRACTICE!!

Usually, DEV/QA has much less data than PROD does. So, your sproc runs faster in DEV/QA.

I saw you used a cursor in the sproc. Could you get rid of it?...

When you set up Maintenance plan, there is an option -- "Remove files older than ...". You can use it to remove the Friday's backup file.;)

So, now, 50 Companys' in one DB? and each one has a table in that 'massive db', right??

If so, you...

In 2000, you need to have a trace, then, get this info.:unsure:

Too long....I did not go through all, but, here is an error:

set nocount on

go

remove that "go"....

----------------

Edit:

Going through the code this time, what the use of ##Temp12122121? I think you could...

I have a similar one: when I right click sproc --> Script Stored Procedure as --> ALTER TO -->... it always gives me CREATE TO....:angry: not sure what's wrong.

Steve Jones - Editor (7/24/2008)

---

You need a variable to do this.

select @cmd = 'update tableA set '

-- cursor start here

select @cmd = @cmd + @column_name + '= ''value'' where '...

michael_pereira (7/23/2008)

---

declare client_cur cursor FOR

select * from Clients where client='123'

...