You can query view INFORMATION_SCHEMA.COLUMNS

select table_name ,column_name from information_schema.columns

where column_name = 'column_name'

Sql Server doesn't have table backup though there are ways you can do this..

1. Create important tables or the tables you want to backup in one filegroup and then take...

Please see 'ceiling' and 'floor' function in bol..

This will do what you want..

NJ

1 how can we check whether the backup is in consistent state or not

See Restore verify_only.. in BOL

2. while restoring the transaction logs on secondary server in log shipping can...

Use this in your script..

select databaseproperty('Database_Name','isReadOnly')

0 = False

1 = True

That is strange...What do you see when you run this..

sp_helprotect null,'LIMSUSA' ----in the database you are trying to connect.

Can you try to drop and recreate this login from security...

Was out for lunch...

Ok..

Did you created ODBC DSN manually or using some connection string to connect to database. If you are creating manually then try creating Sql Native Client DSN...

select top 1 b.database_name ,m.physical_device_name

from backupset b join backupmediafamily m

on b.media_set_id = m.media_set_id

order by b.backup_finish_date DESC

Verify these options

1 The Trusted Connection box is not selected in the System DSN definition.

2 The SQL Server security mode is not Windows NT Integrated should be mixed...

update statistics is advised to improve the performance of queries as after the upgrade all the statistics get outdated. You can skip this step and test connectivity from frontend..

Also change...

you can use script on microsoft site..

Execute script in method 2 in following article..

http://support.microsoft.com/kb/246133/

After this do..

Exec sp_help_revlogin and save the output script to...

I would suggest following :-

1. Execute sp_help_revlogin on sql server 2000 and save the output.

2. Take backup of sql server 2000 database and restore on Sql Server 2005 on other...

Your database is now upgraded to Sql Server 2005 after the restore. No need to do any other upgrade except latest Service Packs if needed.

Also don't forget to update statistics...

What is the version of Sql Server . For Sql Server Express and developer edition by default id allows only local connections.

Go to Surface Aread configuraion and change the...

Change the autogrowth to a fixed size. With an increase of 10% every

resize needs more disk space and resources seeing your database size.

Also for 'select into' change recovery model...