You could do it that way:

IF NOT EXISTS (SELECT * FROM usp_tblDivisionINSERT WHERE DivisionAbbr = @DivisionAbbr AND DivisionName = @ DivisionName)

INSERT INTO…

You’ll might have to modify it to...

This will work on most cases, but in case that the file has more...

Its been a while since I’ve worked with log shipping, but as far as I remember, it simply does the reindex operation on the secondary database just like it was...

If I understood your question correctly, you can use a format file in order to insert data from a file that has different number of values then the table’s columns...

Are you using a backup file that contains few backups of the database? If you are doing a backup and pointing it a file that already exists and has...

Check the creation date of those procedures in the source database and compare it with the Backup's date.

Adi

You can create a table with the needed date and then use a cross join with your original table in order to get all the combinations between each date and...

Notice that both queries are not the same. The second query that uses the between operator will also return records where column SAMPLE_DATE has the date 2003-04-10 in it...

arun.sas (1/18/2010)

What you have written in the statement is correct, but you should convert the date time type by convert (varchar (15), tet.dteTravelDate, 103)

(case when pt.intPointTypeID = 1 then convert...

Matt Miller (#4) (1/15/2010)

.

Keep in mind that may execute under the service account context, which could show you the location of the IIS server serving up...

Only way that I know is to check old SQL Server’s error logs and\or event viewer logs from that time frame.

Adi

There are some tables that you can’t truncate. One of the conditions is that the table is not referenced in a foreign key constraint. Unfortunately even if...

As far as I know, create procedure permissions can be granted (and denied) only on a database level and not on schema level. You could grant it to the...

If I remember correctly this is an extended...

I don’t have here a SQL Server 2000, so I can’t try a solution. One way of doing so is to add a new level to the query. ...