Hi,

You could also use the sp_helpjobactivity for a start_execution_date and no stop_execution_date for that info perhaps?

We are mainly running 2008 in differing flavours. I have not seen any business reasons that have made me consider the additional cost of the new licensing model for the...

logicinside22 (12/30/2011)

---

You can check out from here also

« SQL SERVER – Recycle Error Log – Create New Log file without Server RestartSQLAuthority News – SQL Server Denali CTP1 –...

Gabriel P (3/28/2013)

---

I was asked on an interview how to find deadlock information without using SQL Profiler or running a trace. They didn't give me an answer, but it sounded...

JeepHound (3/28/2013)

---

What are the best tools available for monitoring MSSQL and Oracle databases. Our end goal is to have something usable for DBA's to quickly troubleshoot problems with both...

You would need to question why you would be doing this. Unless there is a reason for the data to be phsically ordered and to be unique by those two...

Manual is safer but.. I have used this in the past for setting an isolation level. You could adapt this

--SET ALL SP's to BE READ COMMITTED

SELECT

o.OBJECT_ID

, name

,REPLACE(REPLACE(REPLACE(s.definition, 'CREATE PROCEDURE',...

Connect to the SSIS instance via SSMS and then look at the build number in the brackets or right click and goto reports > standard reports > general and look...

Perhaps look along the filestream options in SQL server or varbinary datatypes

I may have mis-understood what you are after and this is by no means the most efficient but I think this may be what you are after

DECLARE @WeightValue SMALLINT =...

Amend your dataset so that it returns the data without the spaces like ..

SELECT REPLACE('test space', ' ', '')

perhaps use EXEC sp_MSforeachdb @command1='use ?; SELECT * FROM mytable' ?

From what I remember, Litespeed does not create any extra, above what a normal backup strategy would i.e. backup history, etc. That would be outside of your sizing requirement

An oldie, but I thought I would reply - Once a database is registered as a data tier you can update that database with an existing dacpack

Try recovering from a backup first and then if that does not work try the following : http://www.sqlskills.com/blogs/paul/creating-detaching-re-attaching-and-fixing-a-suspect-database/