I have a dev box and for certain reasons I was using sa to create MPs. Once I’ve changed the sa password I had the same issue. Even worse -...

Running the same command from the passive node works however!

same result

Microsoft (R) SQL Server Log Shipping Agent

[Assembly Version = 9.0.242.0, File Version = 9.00.4035.00]

¸ Microsoft Corp. All rights reserved.

2009-03-26 15:52:54.65----- START OF TRANSACTION LOG BACKUP -----

Even running it...

Max Yasnytskyy (1/5/2009)

---

if your application specifies it's name when connects to the database server following script may work for you

select program_name,count (*)

from sys.sysprocesses

group by program_name

order by count (*)desc

declare @spid smallint

declare...

if your application specifies it's name when connects to the database server following script may work for you

select program_name,count (*)

from sys.sysprocesses

group by program_name

order by count (*)desc

declare @spid smallint

declare appConnections insensitive...

According to this article http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/08/17/948.aspx

SQL Server will write equal amount of data into data files of the same filegroup, provided that amount of free

space in them is same....

Following two scripts may help you. First one gives you a breakdown of permissions on the server level and secon one shows them on the object level. Scripts are a...

You may need to add user to SQLAgentUserRole ....

http://msdn.microsoft.com/en-us/library/ms188283(SQL.90).aspx

below script should work for you

select

a.fechahora

,a.m3salida

,a.m3salida- coalesce(b.m3salida,0)

(

select row_number () over (order by idcontrol) [rownumber]

fechahora

,m3salida

from [dbo].[controlcloro]

) a

left join

(

select row_number () over (order by idcontrol) [rownumber]

fechahora

,m3salida

from [dbo].[controlcloro]

) b

on a.[rownumber]-1=b.[rownumber]

Is it LEFT JOIN you are looking for?

If you have a Visual Studio installed on your PC you can use it to debug stored procedures, it offers a very good way of debugging them.

Stewart Joslyn (7/30/2008)

---

For trivial inserts and deletes, there can be an argument for avoiding stored procedures but, for anything more complex, there are clear performance gains. The biggest bottleneck...

Bert,

If you check each database, you will see under Security\Users a list of users, which will give you a clue what logins you will have to recreate. When you...

how about this

declare table #tmpTable (... put all your columns in here)

SELECT @MyNewSql = ' ...

exactly the same:D