Hi,

Your stored procedure looks great for what I am trying to do but when I tried to run indexoptimize on my user database I got this error

Msg 195, Level 15,...

Thanks Aaron, I did the same and also tried the wizard but I still have the same problem.

Thanks. Using the second link fixed the problem.

Hi,

I am not using a witness server. It is only principal and mirror. I have set the trace flasgs on both instances and checked their status and they are on....

Hi Lim,

Can you please help me fix this error "Neither the partner nor the witness server instance for database "shop" is available. Reissue the command when at least one of...

Thanks that part worked but then I got a new error saying that the database was using bulk-logged. I changed it to full and backed it up again and restored...

Thanks a lot. I see it now. I was trying to right click on the table based SQL 2000 experience. I also checked database triggers under programmability but it seems...

I tried adding -T1400 in the startup parameters using registry but it gave me an error when I starting SQL with semicolon between paramters.

"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER;-T1400

Am I doing...

hi,

do we have do this in the registry because the way I was turning on the flag was using DBCC TRACEON (1400,-1).

I tried adding the parameters T1400 in the...

I am getting the same error after turning on trace flag 1400 and exactly following what microsoft has on its site setting up database mirroring. Can someone help fix it...

Cool this also works great. Thanks again for your help. I really appreciate it.

Thanks that fixed the problem.

That works. Thanks a lot.

Also I wanted to know if you could use 2 cases in the case clause. Like i have the following case

(CASE WHEN Max(SalePrice) > 0 THEN...

Hi Noeld,

when i try using the your query it gives me this error

Server: Msg 156, Level 15, State 1, Line 8

Incorrect syntax near the keyword 'GROUP'.

when i try using the above statement it gives me this error

Server: Msg 156, Level 15, State 1, Line 8

Incorrect syntax near the keyword 'GROUP'.