Viewing 15 posts - 721 through 735 (of 956 total)
Greg Edwards (12/11/2008)
Grant Fritchey (12/11/2008)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 11, 2008 at 11:38 am
To even attempt to get it working, you would have to set trustworthy on, grant unsafe assembly to the database owner, and then try manually registering the DLL's as assemblies...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 11, 2008 at 11:18 am
Follow what Nicholas recommended. There is no reason to incur downtime on the database when a backup/restore process will accomplish the same thing, in a similar amount of time.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 10, 2008 at 4:21 pm
Moderis,
In an environment of that size, automation is going to be your key. You can go out and spend thousands of dollars licensing tools to do the job for...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 10, 2008 at 4:15 pm
SSIS works exactly the same way. When you call it from your machine in Enterprise Manager, the local DTExec is called and it runs the package from the server...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 10, 2008 at 3:54 pm
You can find an example trigger in the Books Online:
http://msdn.microsoft.com/en-us/library/938d9dz2(VS.80).aspx
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 10, 2008 at 3:48 pm
ritesh.saluja (12/10/2008)
Microsoft.SqlServer.Server.SqlTrigger(Name:="AuditCommon", Event:="FOR UPDATE, INSERT, DELETE")
Public Shared Sub AuditCommon()
I am getting error as mentioned below.
ErrorThe method "AuditCommon" in class "AuditCommon.Triggers" marked as...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 10, 2008 at 3:47 pm
I HAVE to do my annual Modern Army Combatives refresher once a year, and that is enough rough housing to last until the next time I have to do it....
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 10, 2008 at 10:33 am
First as Madhu posted, get your deadlock graph and post that here. To do so, on SQL 2000 enable trace flag 1204:
DBCC TRACEON(1204,-1)
on SQL 2005 use 1222 instead:
DBCC TRACEON(1222,-1)
This...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 10, 2008 at 7:37 am
Make sure you turn off Autoshrink if it is on while you are in the options.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 10, 2008 at 7:30 am
Steve Jones - Editor (12/10/2008)
That could have been ugly. I've seen Gail throw people around the mat 😀
I haven't seen that, but it sure would be funny.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 10, 2008 at 7:29 am
Timothy Ford (12/9/2008)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 9, 2008 at 4:14 pm
There is no information in this post as of yet that actually attributes a problem to CLR other than the statement by Dean that CLR was causing the problem. ...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 5, 2008 at 8:42 am
Dean Jones (11/11/2008)
SELECT
SUM( multi_pages_kb +
...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 5, 2008 at 8:32 am
smunson (12/5/2008)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 5, 2008 at 8:25 am
Viewing 15 posts - 721 through 735 (of 956 total)