The problem was fixed once the server was restarted. However, we cannot always restart the server. I would like a solution less dramatic.

Gabriela

Thanks, that was the problem. It works now.

Gabriela

My bad on the parameters order! So, I switched state and severity, I tried RAISERROR(50001,16,1) and I got one step forward. I had the event recorded in the application log....

I tried. Is not working. No record in application log, alert doesn't fire. Must be some setting I miss. The whole thing works fine on other servers, only on this...

Hi everybody,

I found this thread kind of late, but is only now that I've got the problem! I configured an alert on 18278 to net send a message when the...

I think I figured out a way that will remove all files older than 7 days. I will test it in the next days, but it should do the trick....

First, check for the existence of the user guest all the databases that you didn't give access to that login but it can see them. If such user exists, remove...

What atuthentication method uses the server? Is the user member in some Windos groups that has larger permissions on the server?

Did you try to index the view itself?

Check "Indexed view" in BOL. It might give you significant performance gains. A lot of conditions apply to create indexed views, but...

The bcp seems to work fine.

I used something like this:

exec master..xp_cmdshell 'bcp "Select * FROM Northwind.dbo.orders FOR XML AUTO, ELEMENTS" queryout "c:\testOrdersxml.txt" -SWS285\gnTEST -c -T'

Gabriela

Hi John,

Is this script meant to do something useful? Doesn't look like!

Gabriela

Thanks, I read all those articles. The only thing is that if something goes wrong is not easy to remove it. Is why I wanted other opinions.

Thanks, guys!

I am about to install it on production servers and I just want to know what other people feel about it.

Gabriela

SP3 and SP3a are compatible from this point of view. They both show 134218488 when you use

select @@microsoftversion

so yes, you can restore a SP3 master over an SP3a installation. This...

You may check this topic

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_07_3w6r.asp