call.copse (8/1/2014)

---

In light of the QOTD is anyone using synonyms for such purposes yet or would they not work for that? Don't know much about them.

Views have been soured for...

Eric M Russell (8/2/2014)

---

In the IT arena, I believe that resume font accounts for less than it would for those seeking a position in something like marketing, public relations, or...

Is the query returning a crazy huge hunk of data?

Can you try running SSMS on a workstation instead of the server?

Most likely it's a client side error with SSMS, not...

Any idea what query was causing that?

I know this is a 3+ year old thread, but I just started having this problem last night. I have a job that runs on a server and checks...

Just because it is old doesn't mean some of us won't find it to be useful information.

Info that is probably relevant. I've determined by talking with our HW team that this update was installed over the weekend: http://support.microsoft.com/kb/2494120/

Gah! After looking at my situation more, it turned out that there was a synonym involved that was actually pointing to an entirely different server when that SP was...

Interesting. Reinstalling .Net didn't fix it, but a reboot did? We must have a different version of the error...we tried a reboot last night and it didn't make...

I'm getting this same error. Did you manage to figure it out? I was thinking of trying the steps here tonight after hours:

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

george sibbald (2/13/2013)

---

Jason, for an article on the benefits of alter database method and why it is the preferred method for SQL2005 onwards see here[/url]

I would add another reason, with...

Perry Whittle (2/13/2013)

---

Jason Shadonix (2/13/2013)

---

Right...but the mere fact that you have to type in slightly different syntax to attach a database isn't by itself an argument to stop detatching and...

Perry Whittle (2/13/2013)

---

I'm not being snarky that comment is a subtle hint.

The old

EXEC sp_attach_db @dbname = N'AdventureWorks2012', @filename1 =

N'C:\Somepath\AdventureWorks2012_Data.mdf', @filename2 =

N'C:\Somepath\AdventureWorks2012_log.ldf';

The new

CREATE DATABASE database_name

ON PRIMARY (name=mydb_data, filename='d:\somepath\mydbdata.mdf')

LOG...

Perry Whittle (2/13/2013)

---

Jason Shadonix (2/13/2013)

---

But that's just a minor syntax change in the process. [/Quote]

You're joking right? Create and alter database have been enhanced extensively to include extra commands (file...

It's the supported way of moving database files and doesn't involve dropping the database from the system catalogs.

SP_ATTACH_DB is deprecated and will be removed in a future version of SQL...