Perry Whittle (12/31/2008)

---

Daksin

as Adi pointed out you cannot query the database in the norecovery state. Bear in mind with the standy option when log file restores occur users will be...

Table valued parameters exist in SQL Server 2008, but it can only be input...

If you want to reset the identity or just see the next number you can use DBCC checkident statement (you can check about it in books on line), but take...

Another option might be to work with temporary table, but that depends on what you are trying to do and how you are doing it.

Adi

When you create the log shipping you have 2 choices. You can configure restore log operation to be done with norecovery or with standby option. If you use...

In that case you just need to use grant statement. You can read about it on the internet or on you local copy of books on line at ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/c001c2e7-d092-43d4-8fa6-693b3ec4c3ea.htm

Adi

You can run sp_spaceused on your tables to find out the table’s size and which table/s uses more space that you thought that they would. Also don’t forget that...

Ashwin M N (12/30/2008)

---

create table temp (id int identity(1,1),Name varchar(50))

insert into temp (name) select 'IP 20867 Corona'

insert into temp (name) select '19"-RAC - C60184-03'

insert into temp (name) select 'HEEFA Tower...

Maybe I misunderstand you, but if you want your users to be able to read data from the table and not modify the data, you can grant them read permissions...

If you do have admin privileges, then maybe you misspelled the database’s name. If the server was installed as case sensitive, the database’s name is also case sensitive. ...

It is better to write a script that creates the tables and inserts data into the table instead of drawing the table and the columns' values. Pleas have a...

Don’t know if it helps you but whenever a database is detached or is shut down (for example, because AUTO_CLOSE is set to ON), all rows associated with the database...

I don’t think that it is supported to change the SQL Server’s name so it will not include the server’s (OS) name. The fallowing is taken from ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/bbaf1445-b8a2-4ebf-babe-17d8cf20b037.htm (How...

Sorry, but I really have no idea about this one.

Adi

Excellent solution and excellent article. Thank you for sharing both of them.

Adi