karmour (9/1/2010)

---

We applied that KB to our server. We also applied the below fix that was recommended by quite a few post:

http://support.microsoft.com/kb/2265716

We did these late last week and we...

Nice perspective 😀

Simon Facer (8/31/2010)

---

...

SELECT HostName

FROM #Who2

WHERE SPID1...

Yep .... stupid, but hard reality.

Still, just pop the question to the...

You can set a filegroup to be the "default".

Alter database [yourdb] MODIFY FILEGROUP FGUserData DEFAULT;'

This means, if they don't specify [primary] as the objects filegroup, the object will be created...

As from sql2005 you need to be granted the "view definition" to be able to see the actual ddl.

If you are the object owner you have this authority for this...

The benefit of not having the data of your user objects in the primary filegroup, is that in such case, your primary filegroup would only contain catalog info.

This may be...

A real DBA would be ignored at least 75% of the cases :w00t::w00t:

You can use SSMS \ maintenance plans \ select your plan and then select the History information.

You'll see the step that failed and on the bottom of that panel, you...

Jon-538504 (8/30/2010)

---

Thanks I sorted it out

C#

...

System.String.Concat("SELECT [Timestamp], [Subject], [EntryText] FROM [Article] WHERE [Timestamp] = '" +

calArticles.SelectedDate.ToString()...

the retro-question is : What's the datatype of your column [timestamp] ?

- is your db-level 100 ?

- I should be possible to alter your column defs, but you must check the restrictions on sparse columns: http://msdn.microsoft.com/en-us/library/cc280604.aspx

BOL also states sparse as an...

Seems to be a GUI problem.

Can you create the alert and its response manually via a TSQL panel ?

smthembu (8/30/2010)

---

Hi All

I have SQL Svr 2008 R2 & OS Windows 2008 R2 Std, I have created a backup maintenance plan to backup to one of our backup drive. Certain...

ps. (8/30/2010)

---

Hi,

...

I created a test database in 2005 and tried to delete system SP but it did not allow me even though i have sysadmin privilage. Can't test it out...