Also use SP_WHO2 command to know more about the process that is blocking and got blocked.

shannonjk (7/15/2009)

---

Thanks all.

I realized after posting the problem with the statement I executed.

Your tips helped me get the tempdb situated and the sql server instance is up and...

Thanks Adi

You should mention the full file name. Not just the folder name. For example:

alter database tempdb modify file (name = templog, filename = 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\templog.LDF')

And you have copy the...

1) Start the instance of SQL Server in master-only recovery mode by entering one of the following commands at the command prompt. The parameters specified in these commands are case...

Instead of running batch of query using C# code,

create a stored procedure with all these queries and call the stored procedure from the C# code.

Why do you want to use any other operator instead of ;?

The semicolon character is a statement terminator. It is a part of the ANSI SQL-92 standard.

SQL Server 2008 Books...

BOL

Rebuilding or reorganizing small indexes often does not reduce fragmentation. The pages of small indexes are stored on mixed extents. Mixed extents are shared by up to eight objects, so...

The Size in pages column shows that your tables are very small. For such small tables you will not see much difference after rebuilding the index.

What you are trying to...

Service pack installer...

Thanks Stuart

Using SSRS "subscription" it is possible to email a report.

I have done this in SQL Server 2005. I don't have 2000 to check this feature.

Abhijeet Dighe (7/10/2009)

---

I just altered the size of column in table using wizard.

Table is having millions of records. So from 3-4 hrs it is executing alter operation.

I want to kill...

Change the "Copy user trigger" properties to True.

Indexes, constraints, etc. you can replicate in this way. They are not indepent objects. They are dependant on table.

SAT_SQL (7/6/2009)

---

Hi All

as i am new to sql , please let me now weather i can upgrade sql200 to sql2005,

If it is possiable please send some links that ...