Correct, you do not need to provide the number.

Here is...

I am picking up on some terminology issues. For the record, and to clear up the terminology, we need a Server Login and a Database User. The Server Login is...

Something like this?

USE tempdb

GO

CREATE TABLE dbo.three_columns

(

A INT NULL,

B INT NULL,

C INT NOT NULL

);

GO

ALTER TABLE dbo.three_columns ADD CONSTRAINT [ck_dbo.three_columns.C] CHECK

(

(C = 150 AND...

Matthew Cushing (4/17/2012)

---

If I have a stored procedure that returns 0 on success, can I fail if it's not 0? Right now the sql task doesn't return anything, but...

Have you checked your event logs for disk i/o errors? Have you had any system failures lately, i.e. blue screens, raid controller issues, etc.?

How to Recover From Being Locked Out of a SQL Server 2005 database

If you're open to using SSIS to FTP the file then are you open to using SSIS to also get the data into the file in the first place? This...

SQL Server can be scaled-out by leveraging Service Broker but it requires a home-grown solution that would be very labor-intensive to implement in terms of the amount of development required....

I have no sympathy for those folks 🙂 I would tap my opportunistic side...

Which version of SQL Server are you using? The last message from Microsoft in June 2011 says "This will reflect in an upcoming release of SQL Server." and the item...

Found this. Says State = 16 means the users failed to log into the target database.

PS if the "machine" is the local machine it could be a service running under the "local system" account. Even in that case my recommendation about finding the source before...

The $ after the name signifies it's a machine account, i.e. the name before the $ identifies a server. It means that something running on that machine tried to log...

winston Smith (4/16/2012)

---

all attempts were run from the actual server.

When I say I remote in, I meant I'm now at home and so had to remote into the servers,...

winston Smith (4/16/2012)

---

Perry Whittle (4/16/2012)

---

winston Smith (4/16/2012)

---

I ran setspn -l server.domain and got a list of all SPN's for the server.

I then ran setspn -d MSSQLSvc/server.domain domain\serviceAccount to remove the...