srilu_bannu (11/18/2009)

---

I have seen the execution plan ,in that it is scanning rows .i heard that seek performs good than scan.

but i don't know how to create clustered index seek...

Mark_Pratt (11/18/2009)

---

Regarding backups.

* If you run a full backup, you get a .bak file

* If you run a tranaction log backup, you get a .log file

You can change the file...

Good.. you have everything...

shanila_minnu (11/18/2009)

---

Bru Medishetty (11/18/2009)

---

Use the Following T-SQL Command

SELECT DATABASEPROPERTYEX('DBNAME', 'Collation') SQLCollation;

You can also right click on the database select properties. In the general page of the Properties window, the...

Obviously, a database backup will have performance impact on the server. That is the reason...

To copy the data, you need to create the new database with desired collation and use Import/Export wizard to copy the data onto that database (be it local or Remote...

Use the Following T-SQL Command

SELECT DATABASEPROPERTYEX('DBNAME', 'Collation') SQLCollation;

You can also right click on the database select properties. In the general page of the Properties window, the last property is...

Is it a thrid party tool? Any idea...

While attaching the Database from SSMS, you...

alaminfad (11/17/2009)

---

but when i try to restore the database , i get this message [Directory lookup for file ...Operating system error 21]

what is it wrong...

You can for sure take a local backup on to the Production Server and then use the \\ProductionServerName\DriveName$ to map as a network drive on your local Server and copy...

Well, I don't have an answer readily available.

A workaround can be planned. Do you have any reason not to have a backup on the remote server?

Some info would...

Yes it is possible, I have not done this, but it is worth a try.

Use Universal Naming Convention (UNC) which would be something like this

\\servername\sharedfoldername\FileName

You need to have the...

You have mentioned that you tried disabling the windows firewall and the Server\instancename to connect.

Can you check the IP Address and the Port No and use it conjunction as IP...

luckysql.kinda (11/17/2009)

---

This is a demo which I am trying to run many sql queries in the batch file later. The batch file can contain the T-sql commands but I feel...