do you have service broker enabled ? if so have a look at the queues and see what is in there .

Ramana P (5/17/2012)

---

Hi All,

I have table like this,

while I am altering the column, datetime to Int , it is throwing error.

I doesn't have any data in table '

GO

CREATE TABLE tblConvert(ID...

also have a look at the performance condition alerts - such as lock wait time, deadlocks per second etc

you need to do the following

1) ensure database mail is configured

2) go into sql server agent and set up an operator with your email address

3)in sql agent set up an...

can you post the error log that it created in the backup directory

can you clarify what you mean by file lock please?

have a look at this article recently posted

http://www.simple-talk.com/sql/t-sql-programming/the-tsql-of-csv-comma-delimited-of-errors/

i...

you should read the MS documentation

http://msdn.microsoft.com/en-us/library/ms189852.aspx

look at the article and take note of the configurations involving witnesses

also look at high safety mode and high performance mode - i think you...

krypto69 (5/16/2012)

---

Yes, our users would be re-directed to the server in the other state when there is a chance of a hurricane (florida).

Do I still want to look at Db...

lynn beat me to it again

declare @TimeInterval int=1

declare @dt_Start datetime

declare @dt_End datetime

exec pr_GetLastInterval]

@TimeInterval,

@dt_Start OUTPUT,

@dt_End OUTPUT

select @dt_start,@dt_end

the first one orderd by to.date of call - if there are multiples at the same time then it will depend on the internal storage in the table t0

if there...

Geoff A (5/16/2012)

---

you say the other server in another state is for DR.

why would you use replication? database mirroring could provide DR for you across the WAN.

do users in the...

i think this might answer your question

Update b

set b.run_daily_avg_consum = cast(a.run_daily_avg_consum as decimal(15,5)) *.7 + b.Daily_avg_Consumption *.3

From [Stage1W_Dim_Readings] a inner join [Stage1W_Dim_Readings] b on

a.pod_no = b.pod_no and a.Read_Seq_Pod...

beware of using syscomments for this - you can get more than one row and the keyword you look for can be split across 2 rows

i would recommend finding them...