I couldn’t understand what you want. Can you post the question again, but this time add a script to create a demo table, then write some insert statements to...

Take a look at BOL (Books on line – the help file that comes with SQL Server) at Bulk insert statement. It seems that this is just what you...

This is due to a limitation of openquery. When you use openquery function, you can not use variables in it. This means that you can use dynamic SQL...

steveb (6/8/2009)

---

Sumanta Roy (6/8/2009)

---

Hi,

The transaction log backup of the user databse has taken the almost disk space(size 122GB). The datbase recovery model is set to full. What is the best...

Just to add on Erwin's response. In order to avoid this problem in the future you should consider doing one of those options:

1) Modify the database's recovery model to...

vik_steve (6/8/2009)

---

The applications is web based (php). I have managed to stabilise the database:

The error in log file was:

Autogrow of file ** in database ** cancelled or timed out after...

You should try and find out the cause of the blocking and not recreate the TempDB or do something else with no connection to the blocking problem that you have....

Maybe there is a better way of doing it, but the way that I did it used 2 Common table expression (CTE). First here is a small script to...

yuzzelpiccici (6/4/2009)

---

Thx for your help Adi.

But, if i want to create table like this :

CREATE TABLE [WeatherInfo] (

[WeatherID] [int] NOT NULL ,

[DateNow] [datetime] NOT NULL ,

[TimeNow] [datetime] NOT NULL ,

[Until]...

I still have few questions. If there are few records with the same value in UserUID and Code columns, but 2 of them have today as StartDate and...

I don't know of a way of doing it with the GUI, but if you'll read the article that you referred to in your post, you will find all you...

declare @time datetime

select @time = getdate()

select @time, convert(char(8),@time,108) as OnlyTime1,

dateadd(dd, datediff(dd,@time,'19000101'),@time) as OnlyTime2

Adi

It depends. If the error happened on a none clustered index, then you can just drop the index and recreate it. If the error is on the clustered...

Maybe you network admin is blocking the communication between the servers with firewall.

Adi

Tables don't have any order for the records, so you need to specify what you mean when you want to compare the value of column in a record with a...