Viewing 15 posts - 11,776 through 11,790 (of 49,552 total)
Not the error message that you get. Open up the SQL Server error log and see if there are any errors in there that may suggest why the trigger failed....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 3:39 pm
Please look in the SQL error log and see what error messages were logged there from that login trigger.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 3:21 pm
Still need...
GilaMonster (9/5/2013)
Look in the SQL error log. iirc, errors that occur in a login trigger's execution are logged to the error log. Check what's there.
As for permissions, unless you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 3:14 pm
Look in the SQL error log. iirc, errors that occur in a login trigger's execution are logged to the error log. Check what's there.
What's the schema of that table?
What database...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 2:47 pm
Root page full, root page splits into two (old root page and newly added page). Cannot be two root pages, to another level is added above with a single page,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 10:41 am
btw, there isn't a SQL Server 2012 R2. There's only SQL Server 2012.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 10:24 am
Attach is not the only way to move a database physically and restore doesn't modify databases (doesn't create them technically, the database was created previously if a backup exists)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 8:54 am
btw (because I'm sure someone would bring it up sooner or later)...
MySQL has this kind of thing 'built in', because that's how MySQL does backups (or did last time I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 8:49 am
sqlnaive (9/5/2013)
"Attach is used to move a database physically and restore is used to create/modify database as per requirement based on backups"
If you like. It's not true though.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 8:42 am
Many of the 3rd party backup tools allow you to restore individual objects from a normal backup. If that's an option, it might be worth looking into.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 8:04 am
If you must use DTA, don't run it against production, don't set it to automatically implement recommendations and don't set it to remove indexes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 7:14 am
Before you attach, there is no database. Just files in the file system. So no, that's not correct.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 7:08 am
What information?
How to do it? (you should know that)
Reasons to do it?
Something else?
A project plan is a list of tasks and times to complete a defined project. No project,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2013 at 4:18 am
No such thing as a new leaf level. Levels are created when the root needs to split and a new root added above that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 4, 2013 at 5:52 pm
patrickmcginnis59 10839 (9/4/2013)
Easily marked doesn't seem to be necessarily an impossible barrier. .... for that matter I'm sure they know how to mark a test.
The lab...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 4, 2013 at 5:35 pm
Viewing 15 posts - 11,776 through 11,790 (of 49,552 total)