Am I not able to access URLs because it’s blocked?

OR

Is it a SPAM post?

I am not sure at the moment (& also can’t verify it on EM/SSMS) but EM usually allows you to script your actions. Try it with EM & save the...

mandirkumar (12/29/2011)

---

The solution u gave will work fine, but how to know the current date format in sql, so that i can give that dateformat as

SET DATEFORMAT Current Date...

If you don’t want a user to perform DML operations, revoke or deny those permissions.

For More:

http://msdn.microsoft.com/en-us/library/ms187719.aspx

http://msdn.microsoft.com/en-us/library/ms173724.aspx

It's worth reading following KB article.

FIX: You receive error 666 when you rebuild an index online on a partition scheme in SQL Server 2008 or SQL Server 2008 R2

http://support.microsoft.com/kb/982441/j/en-us

Well said.

David Moutray (12/28/2011)

---

David Portas makes a good point in his post. (I was following that thread until you guys...

george sibbald (12/27/2011)

---

can I then recommend that you check logins still have...

The error indicates it’s a password mismatch. Create ODBC DSN once again and try it freshly.

MyDoggieJessie (12/28/2011)

---

You could create the maintenance plan to delete the files (using the Maintenance Cleanup Task) then "script" it out so you can see the TSQL that is generated by...

Per BOL:

--Backup Set Options

COPY_ONLY

| { COMPRESSION | NO_COMPRESSION }

| DESCRIPTION = { 'text' | @text_variable }

| NAME = { backup_set_name |...

PaulB-TheOneAndOnly (12/28/2011)

---

frankcastle509 (12/28/2011)

---

you are probably looking to completely redesign your system and I think you should hire an expert for all your queries because you got lot of things to...

Sean Lange (12/28/2011)

---

By far the easiest way is to truncate your new table, change your ID to identity (if it isn't already), then just insert your data. Don't over complicated...

Please check Windows Event Log. It logs service failure messages with some information.

David Moutray (12/28/2011)

---

...

So, now I have things like massive tables with non-atomic fields or Entity-Value-Attribute structures. Every time I point out the problems such things can cause, someone says,...