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...

I'm in favor for the options Leo.Miller provided :w00t:

as already stated: it depends.

If that column is used in where clauses, as a join argument, or order_by\group_by, it may be good to create an index for that column.

Should it...

Horrible screenshot to read :ermm:

Does your instance have an E-drive ?

Does that E-drive contain a path called "program files\microsoft sql server\Data" ?

Does your sqlserver service account have the needed auth...