It's probably just a question of semantics. As I understand it, a high availability server can form part of a DR strategy. I don't think it matters whether...

If you want to copy the whole database, backup and restore is much cleaner. I'd only recommend snapshot replication if there are only certain tables that you want to...

We need a bit more information, please. Which database(s) will your DR strategy cover? I assume your Staging database is updated from the external sources and then your...

Inserts, etc are still logged in Simple mode. They're just removed more quickly. Have you tried switching to Full recovery mode and comparing the time taken?

John

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...