Viewing 15 posts - 166 through 180 (of 218 total)
This might help. It represent joins as venn diagrams.
January 18, 2012 at 9:27 am
To get the last time the sql service restarted you can use:
Kevin Devine says:
select login_time from master.sys.sysprocesses where cmd='LAZY WRITER'
source: http://www.sqldbadiaries.com/2011/03/14/find-the-last-reboot-time-of-the-server/
This article also shows techniques from the server also.
December 21, 2011 at 10:48 am
This should point you in the right direction:
Runas /netonly
Some applications don’t support stored user names and passwords. For example SQL Server Management Studio will not be able to connect to...
November 30, 2011 at 2:45 pm
Do you have the RESTORE script you are attempting to use?
I'm assuming because you stated you are missing the Data path that the file is being restored to the wrong...
October 7, 2011 at 10:46 am
SQLRNNR (9/15/2011)
Ray K (9/15/2011)
Stuart Davies (9/15/2011)
SQLRNNR (9/14/2011)
Revenant (9/14/2011)
SQLRNNR (9/14/2011)
crookj (9/14/2011)
Ray K (9/14/2011)
Daniel Bowlin (9/14/2011)
Pressurecooker
Rice Steamer
Jasmine
Thai
Lemon Grass
Blue Grass
Tall grass (I need to mow my lawn!)
tumbleweed
E-Mail firewall device.
September 19, 2011 at 2:06 pm
I use the following site to keep up with patch versions
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
September 19, 2011 at 1:34 pm
SQLISA (9/12/2011)
I have a new install of SQL 2008 SP2 Version 10.0.4064. When I look at the builds for SQL 2008 I do not see this version. Any ideas?Thanks
MS11-049 (kb2494089)...
September 12, 2011 at 2:14 pm
Revenant (9/12/2011)
SQLRNNR (9/12/2011)
flameold
retirement
September 12, 2011 at 11:04 am
Marios Philippopoulos (9/7/2011)
Is there a way to "kill" reports running for too long, as identified from dbo.RunningJobs?
The only way I know of how to do it outside of Managment Studio...
September 7, 2011 at 10:51 am
Marios Philippopoulos (9/6/2011)
eccentricDBA (9/6/2011)
Try dbo.RunningJobsThanks, but won't this only give me reports running as subscriptions?
It gives you current excutions. Although it won't help for a report that is cached....
September 7, 2011 at 8:47 am
Try dbo.RunningJobs
September 6, 2011 at 2:13 pm
SELECT name, type_desc, is_disabled
FROM sys.server_principals
August 19, 2011 at 2:54 pm
SQL Server 2005 SP4 resolved this issue.
August 18, 2011 at 11:46 am
The only thing I can think of would be to use the Report property Description field found under General.
That filed is stored as Description in the Category table in the...
August 18, 2011 at 8:32 am
The following would be a solution:
WITH
Object AS
(SELECT o.object_id as ObjectID
, s.name as SchemaName
, o.name as ObjectName
FROM AdventureWorksDW.sys.objects as o
LEFT OUTER JOIN AdventureWorksDW.sys.schemas as s ON s.schema_id = o.schema_id)
SELECT...
August 12, 2011 at 1:18 pm
Viewing 15 posts - 166 through 180 (of 218 total)