OK, start by making a backup now. It's fairly easy to get your server into single user mode - there's plenty of information out there on how to do...

Do you have a good backup you could restore from? That's the preferred solution.

John

Does it work if you cast it to another data type, the same way as you've already done for StartTime and ContainerStartTime, amongst others?

John

Does your SQL Server audit failed login attempts? If it does, what is written to the errorlog at the time of the login failures?

John

Jim

A vbs script isn't a SQL Server solution, so it's a little outside the scope of these forums. I think it would be simpler to create a batch file,...

You need to create a user for user_01 in the new database. See the CREATE USER topic in Books Online.

John

Your original requirement was a T-SQL query which, if I understand correctly, isn't going to work against an Oracle database. You'll need to go to an Oracle forum to...

Read about the SUBSTRING function or the LIKE operator. Either of those should give you what you require.

John

I take it you have a table called Status or something like that, to which the main table has a foreign key constraint? That table would contain values such...

New letter, new row:

INSERT INTO order_status (order_id,order_status, order_desc, letter)

VALUES

('025', 'Dispatched', 'Black tailored coat ','DPT notification'),

('025', 'Dispatched second notification', 'Black tailored coat ','DPT2 notification');

You may need to change your data types...

rot-717018 (10/19/2012)

As I wrote earlier, I'm not english nor am I american ... I'm luxembourgish/french.

What would be the correct formulation for the above...

If you want to release space on disk then you need to shrink the database. See DBCC SHRINKDATABASE. Beware, though - if your database is likely to grow...

That'll revoke the deny, but won't necessarily restore the permission. You'll need to do an explicit GRANT if the user doesn't have the permission through any other avenue.

John

Nobody has so far commented on the four distinct values in your column. In one of Gail's articles that you're about to read, it says this:

It usually works out...

Didn't we go through this yesterday?

John