Watch out for SQL 2005 has issues with ORDER BY in the definition of the views!

dva2007 (2/25/2009)

---

hi,

it does look like

"1,"company name","this is a description,company in USA"

But in bulk insert the field terminator is "," so it is getting confused at description where it finds...

Chad Crawford (2/25/2009)

---

I thought about that, but was...

Things are applied depending on how "critical" they are for you. At least that's our case 😀

Correct. Increasing the size is just a metadata operation. Reduce it and you could be in trouble 😉

Yes.

I have experienced it in the past . I am 100% 2005 now and it has been a...

Follow the links on the tutorial: http://msdn.microsoft.com/en-us/library/aa337389(SQL.90).aspx

Follow the links: http://msdn.microsoft.com/en-us/library/aa337389(SQL.90).aspx

One question none asked was if they used EE on all those DB servers... Sounds like a lot of licences ($$$$)!

I like than one!

Not only we restore *all* our backups we run checkdb and data_purity checks on all our "main" user databses as frequent as possible. It is all automated and when something...

it does not really matter if the LOB is in-row or not. if there are LOB columns you hit the limitation.

Louis Kapp (2/24/2009)

---

No I dont think it is my friend...

I tried to use it to run two jobs and for some reason the second one starts before the first one...

What happens when you run UPDATE STATISTICS {tablename} WITH FULLSCAN ?

Louis Kapp (2/24/2009)

---

Oh SQLServer and its stored procs....

So to run two jobs consecutively would I do something like this?

USE msdb ;

GO

EXEC dbo.sp_start_job N'Job_1' ;

GO

EXEC dbo.sp_start_job N'Job_2';

GO

Or would I put each...