Viewing 15 posts - 7,486 through 7,500 (of 7,614 total)
You did give SQL this instruction when creating the trigger:
WITH EXECUTE AS 'DOMAIN\AnonLogin'
Maybe you can use ORIGINAL_LOGIN( ) to still get the actual original login name.
February 14, 2012 at 11:59 am
Seconded -- the Developer Edition of SQL is great for learning -- and cheap!
For SQL Server knowledge, check out "Inside SQL Books" by/with Kalen Delaney.
For T-SQL, check out books by...
January 17, 2012 at 1:14 pm
On the really large tables, looks like you are using LID, varchar(100), to join / match on them.
Is there an index on LID on the large tables? If so,...
January 11, 2012 at 2:39 pm
Running SELECT * FROM test.dbo.sysfiles I got the following
To be safe, you really should run against test.sys.database_files, since that is what SQL is actually looking at ... notice...
January 10, 2012 at 2:48 pm
Given that this is SQL 2008 (or SQL 2005 at least), you mean:
SELECT *
FROM test.sys.database_files
right? 🙂
January 10, 2012 at 2:22 pm
Ok.
See what is in the sys.master_files "table" for that db:
SELECT *
FROM sys.master_files
WHERE
database_id = DB_ID(N'test')
January 10, 2012 at 2:19 pm
Once the SQL Agent logs have scrolled off -- that is, been renamed as SQLAGENT.1, ~.2, etc., by SQL Server -- you can just go into Windows and delete them....
January 10, 2012 at 1:58 pm
Verify the logical file names are what you expect them to be.
USE <your_db_name>
EXEC sp_helpfile
--Or: EXEC <your_db_name>.dbo.sp_helpfile
The first column will show the logical file name, which, of course, must match what...
January 10, 2012 at 1:54 pm
The need for the end user to define columns (not fields) might just be the most obvious evidence of a bad design....
Do you have an example where such a...
January 10, 2012 at 1:51 pm
That physical file copy thing's not looking so bad now, is it? :-):-)
January 3, 2012 at 2:56 pm
SQL 2005 is different from either.
http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx
1. Insert the SQL Server 2005 installation media into the disk drive.
2. Use the following syntax:
start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1...
January 3, 2012 at 2:55 pm
Excellent point.
For SQL 2008, you must do run:
setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=instance_name
/SQLSYSADMINACCOUNTS= accounts [/SAPWD=password]
If in Mixed mode, specify the /SAPWD; if Windows/Authenticated only, leave it off.
Have to admit I...
January 3, 2012 at 2:52 pm
First, make a copy of the existing master data file(s) and log file (in Windows, not a SQL BACKUP). You may be able to read some data out of...
January 3, 2012 at 2:31 pm
I've read the whole thread. Very interesting discussion.
But I don't understand the claim that "Optimistic Locking" has no overhead.
What about all those rollback/undo errors in Oracle? Oh those...
January 3, 2012 at 2:05 pm
Viewing 15 posts - 7,486 through 7,500 (of 7,614 total)