Viewing 15 posts - 2,296 through 2,310 (of 7,498 total)
Just use a scheduled sqlagent job that runs your script for every userdb.
February 23, 2011 at 3:05 pm
I advise to just talk to your sysadmin/dba and request what you want.
They will most likely be glad to point you to the request procedure or eventually the implemented segregation...
February 23, 2011 at 3:03 pm
You cannot.
- #tablename temp tables are cleaned up after the connection closes.
- ##tablename (global temporary tables) can only be dropped if they are no longer used by an active connection.
What...
February 22, 2011 at 1:30 pm
primitive but working ....
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server
Imports System.Management
Partial Public Class UserDefinedFunctions
<Microsoft.SqlServer.Server.SqlFunction()> _
Public Shared Function ufn_GetOSStartUpTime() As SqlDateTime
...
February 22, 2011 at 3:43 am
I didn't find it in sys.dm_os at a first glance ...
so here are some examples of how you can do it with WMI and/or Powershell
http://social.technet.microsoft.com/Forums/en-GB/ITCG/thread/c4e577d3-ee7f-42a7-83da-375361d56bde
Integratable in CLR...
February 22, 2011 at 12:50 am
GilaMonster (2/21/2011)
GSquared (2/21/2011)
jcrawf02 (2/21/2011)
Jeff Moden (2/21/2011)
jcrawf02 (2/21/2011)
Jeff Moden (2/21/2011)
WayneS (2/20/2011)
February 22, 2011 at 12:22 am
YSLGuru (2/21/2011)
February 22, 2011 at 12:12 am
Another ref to put in the "must read" section !
Very good job !
Is there already a "sql server db logs / recovery models " section in SSC Stairways[/url]?
February 21, 2011 at 1:30 am
It depends 😉
For investigation / development I use SSMS and TSQL.
I have a script library which I built over time, so starting from there I'm fairly at ease.
With SSMS...
February 21, 2011 at 12:50 am
just a quick copy/paste from my script library:
-- how to determin SQLServer Uptime
-- zie Tracking Uptime by Brian Moran http://www.winnetmag.com/SQLServer/Article/ArticleID/38042/SQLServer_38042.html
--
-- dd 20060912 JOBI - aangepast voor SQL2005 (DMV)
--
--...
February 20, 2011 at 2:46 pm
Indeed, interpreting the install log files is a PITA for everybody.
the error messages start before the registration errors you posted.
And yes, the timeout messages mostly are a result of another...
February 20, 2011 at 11:49 am
IMO schema can be used in at least two ways:
- to outline data collections cfr Adventureworks db
(not coupled to an application !)
- to ease...
February 20, 2011 at 10:27 am
I would prepare a job for that and link that one to an alert.
All your test users have to do is raise the error and the restore job will get...
February 20, 2011 at 10:06 am
I always kick out sqlexpress whenever I need to install any other version of sqlserver.
SQLexpress is fine, but it may generate conflicts with the other versions during install, upgrade, hf,..
(during...
February 20, 2011 at 1:28 am
AFAIK no.
- what's the need for this to be in a sproc ?
- Can't you use a sqlagent job or a sqlcmd to perform the restore and other needed actions...
February 19, 2011 at 11:17 pm
Viewing 15 posts - 2,296 through 2,310 (of 7,498 total)