What's the error that you're getting?

Yes you can. In the properties window in Management Studio for the server (right click on the server in Object Explorer, select Properties from the menu). Click on the "processors"...

Well now I can't recreate it. Nuts. I should have kept that code I had that generated it.

That may be an issue as well, but if you try to hop a database and reference a CTE, you'll get...

I'm stuck. I thought maybe you were trying to create a temporary global procedure, but I just tried it and those allow for temporary tables as well.

My confusion comes from two sources, I don't understand what an sp_procedure is. A stored procedure:

CREATE PROCEDURE MyProcName

(@MyVariable varchar(50))

AS

CREATE TABLE #MyTable (MyId int);

INSERT INTO #MyTable

(MyId)

VALUES

(1),(2),(3);

GO

Absolutely can support temporary tables, so...

I guess I wasn't thinking of the data types as "developer" specific information. But yeah, I love spatial data, so there's one.

It's because you're trying to run it across databases. The CTE created in the database you're in, not the database you're running against.

I'm unsure of how to resolve that. I'll...

Kathi's article on recovery to a point[/url] in time is very good. I have one too[/url]. Basically, assuming you can answer Gail's question with a "yes" this is what you...

From the developer point of view? Honestly, not much. Most of the changes were in the BI space and in administration.

Koen (da-zero) (1/11/2011)

---

Grant Fritchey (1/11/2011)

---

On #3, if you change the data type on existing data, you face the possibility of data loss, which, for most businesses, is a bad thing....

Hard to know, but it sounds like there is probably a trigger on the table, your security setting is working with it, your co-workers is not. But, honestly, that's a...

It sounds like you have a transaction rollback within one of the procedures, but no begin transaction statement. You have to either add a begin trans statement or remove the...

I would suggest you take a look at Michelle Ufford's scripts on index rebuilds and defrags[/url]. She has the most comprehensive and stable approach out there.

I don't completely understand what you're trying to do there, but yes, cursors are absolutely going to cause performance to slow down in most circumstances, regardless of whether or not...