Viewing 15 posts - 4,456 through 4,470 (of 7,168 total)
It means there can be 32,767 user connections at any given time. This is not to say that millions of people could not use the same database server within the...
April 18, 2012 at 9:27 am
george sibbald (4/18/2012)
THE-FHA (4/17/2012)
April 18, 2012 at 9:18 am
Luk (4/16/2012)
So not specifying the file number after "log_" assumes that it will point to the first trace file available?
Correct, you do not need to provide the number.
Here is...
April 17, 2012 at 5:22 pm
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...
April 17, 2012 at 4:39 pm
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...
April 17, 2012 at 3:20 pm
Matthew Cushing (4/17/2012)
April 17, 2012 at 3:08 pm
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.?
April 17, 2012 at 2:09 pm
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...
April 17, 2012 at 11:32 am
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....
April 17, 2012 at 10:20 am
hiram.osiris (4/17/2012)
This warning message will be kind of annoying for developers who are used to the GUI.
I have no sympathy for those folks 🙂 I would tap my opportunistic side...
April 17, 2012 at 9:58 am
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...
April 17, 2012 at 9:56 am
Found this. Says State = 16 means the users failed to log into the target database.
April 16, 2012 at 9:45 pm
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...
April 16, 2012 at 5:35 pm
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...
April 16, 2012 at 5:33 pm
Viewing 15 posts - 4,456 through 4,470 (of 7,168 total)