Actually, the best way to verify a backup file is to do the restore.

Yes, that is how I installed SQL Server on my laptop.

Does this help you? You will have to modify it for your use.

WITH CTE AS

(

SELECT

name as TableName,

...

For the heck of it, here is another solution:

WITH

E1(N) AS (

SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION...

This:

SET IDENTITY_INSERT dbo. ON

insert into dbo.

select * from dbo.[A] where reqid = 201

SET IDENTITY_INSERT dbo. OFF

Something like this:

(SELECT TOP 100

ABC,

XYZ,

... etc

...

Charmer (3/21/2012)

---

Hi friends,

i try to run some T-SQL statements in ssms like insert and update left outer join with 5 tables...due to large records it takes too much time..

so if...

Is the application running off an application server or the client desktop?

I'll start by saying it depends.

Having a master procedure that calls the correct child procedure based on the parameters passed is definately one way to do it. The complexity...

Also, in comapability level 80 (SQL Server 2000) you don't have access to new system tables and dmvs introduced in SQL Server 2005 and expanded in SQL Server 2008. ...

Steve Jones - SSC Editor (3/21/2012)

---

Lynn Pettis (3/21/2012)

---

Some people. Let's report a problem trying to save changes from the UI but able to do it with an ALTER TABLE...

Some people. Let's report a problem trying to save changes from the UI but able to do it with an ALTER TABLE statement and ask if others have seen...

Try it in a sandbox database with a table you don't care about.

There is an option you have to change to in SSMS.

Tools -> Options -> Designers -> Table and Database Designers

Instead of just having someone do the work for you, take what you have been shown and see if you can answer the question yourself. IF you have problems...