Debra

If you don't have more than one update in any particualr second, you could do something like this:

select datediff(s,'01 Jan 1980',getdate())

If your updates are more frequent than that, you could...

Debra

Have you tried NEWID()?

John

Debra

I think the simplest way to achieve what you want is with an identity column. If this is a new table, add the identity column before you insert any...

Yes, there is. Look up the sys.database_permissions metadata view.

John

If EXCEPT works for you, then go with it, although I don't think you need to waste time concatenating into a single column - just specify both in the query...

What happens if you try to assign permissions to individual tables? Choose a table and execute this:

GRANT SELECT ON dbo.MyTable to NPQuiggin

John

Nigel

According to Books Online:

The names of users that are mapped to SQL Server logins, certificates, or asymmetric keys cannot contain the backslash character (\).

What is the actual name of the...

Shouldn't be too complicated... what have you tried so far? What I'd do is use a LEFT JOIN to identify which records are to be deleted, and a RIGHT...

OK, I don't think you can just back that query out. So what you need to do is restore to a different database, then do something like this:

UPDATE d

SET...

Do you have a backup of your database? If so, start by backing up your transaction log now and then restore the database to a different location and apply...

Yes, we can help. But we'd rather you attempted it yourself. We can't do all your debugging for you. You need to understand what the code does,...

Please don't post the same question twice. It wastes your time and ours. Answered here:

http://www.sqlservercentral.com/Forums/Topic446786-146-1.aspx#bm446789

John

I'm sorry, but this doesn't make any sense to me. Please will you post your table structure in the form of a CREATE TABLE statement, and some sample data...

Can you show us what you've tried, and then maybe we can point out where you're going wrong? Otherwise it's too much like we're doing all the work for...

Be warned that if you change the collation of the database so that it is different from the rest of the server, and your application uses temp tables, you could...