Viewing 15 posts - 12,406 through 12,420 (of 49,557 total)
DivyaMohankumar (7/11/2013)
5) Now my question is how can i get the old values in the table , as i inserted.
Get a backup that was taken before the update was done,...
July 11, 2013 at 6:13 am
Ok, so it's not actually running as 'sa'
Can you security properties for that login, whether it's mapped to any databases and if so what the default schemas are?
July 11, 2013 at 1:16 am
Can you add a bit to that step that writes into some log table the database user name being used and the login name?
Suser_Sname() for login and USER_NAME() for database...
July 10, 2013 at 3:56 pm
Any SQL Agent proxies in place?
July 10, 2013 at 3:21 pm
Contrived, but maybe you'll be able to use this as a starting point.
CREATE TABLE Employees (
ID INT IDENTITY(0,1),
EmployeeID AS ISNULL(ID+5000000,0) PERSISTED,
FirstName varchar(50),
LastName varchar(50),
Library AS (ID+1832) PERSISTED,
Food AS (ID+880101802147) PERSISTED
)
ALTER TABLE...
July 10, 2013 at 3:20 pm
If SQL Agent is running as sa, then it will be running under the dbo user in the database and hence it's default schema is dbo.
July 10, 2013 at 2:32 pm
Ok, so how is the Employee number calculated, how is the barcode calculated? How is the Employee food calculated? Are they all just straight incrementing from the previous number?
Can you...
July 10, 2013 at 1:12 pm
ktager (7/10/2013)
Gail, thanks, I was going to do some testing on controlling it myself. Unfortunately, there is no was to use the Identity field to calculate off of.
Why...
July 10, 2013 at 12:04 pm
Start->Program Files->Microsoft SQL Server->Documentation and Tutorials->SQL Server Books Online (or press F1 in Management Studio)
July 10, 2013 at 9:40 am
The only auto-increment in SQL 2008 is the identity. You can try and roll your own increment (easy to get wrong) or maybe you can set up the other two...
July 10, 2013 at 9:34 am
It's exactly the same as mirroring with a witness, you just leave out the step where you configure a witness. It's all detailed in Books Online, all the major options.
July 10, 2013 at 9:26 am
Without shutting SQL Server down, you cannot copy the files of the system databases.
July 10, 2013 at 8:48 am
poratips (7/10/2013)
July 10, 2013 at 7:56 am
dwain.c (7/9/2013)
Thanks for the clarifications. I take it you're saying that even with a MAXDOP 1 on the simple SELECT it doesn't guarantee row ordering.
The only thing that guarantees...
July 10, 2013 at 1:54 am
Viewing 15 posts - 12,406 through 12,420 (of 49,557 total)