NO!! (*&#(*$&#W%$&83w4&$@!$^#

"Insert Error: Column name or number of supplied values does not match table definition."

Argh!

oh, but I could put a default value on that datetime column...

It also looks like you can't insert another column for each row returned by the INSERT INTO ... EXEC.

For example, this gives me an error:

CREATE TABLE #mytemptable

(

myserverrole VARCHAR(50) DEFAULT @@SERVERNAME

,mymembername...

Thanks. I didn't think to look there.

Regarding the "more than one result set" -- that would mean doing an INSERT INTO {table} EXECUTE SP_MONITOR would fail (as an example)?

I'll...

http://msdn.microsoft.com/en-us/library/ms188055(SQL.90).aspx ==> Except and Intersect have no mention of "-"

http://msdn.microsoft.com/en-us/library/ms190276(SQL.90).aspx ==> Operator order doesn't list except

http://msdn.microsoft.com/en-us/library/ms189826(SQL.90).aspx ==> Transact-SQL Reference lists:

- (Negative) (Transact-SQL)

- (Subtract) (Transact-SQL)

But it does not list a...

RBarryYoung (4/8/2009)

---

Jochen Vleming (4/8/2009)

---

I totally...

This post agrees that it processes, but doesn't do anything: http://www.dbtalk.net/microsoft-public-sqlserver-olap/hey-my-cube-empty-what-357327.html

Jeffrey Williams (3/26/2009)

---

The one thing to keep in mind is that you don't want to hit an autogrowth event - you just want to have it set in case you...

Also see: http://msdn.microsoft.com/en-us/library/ms143736.aspx

Setup provides a Server Configuration page in the Installation Wizard so that you can configure the services that are part of the current installation. The installation does...

I'm not familiar with sp_helptext but I did grab the mssqlsystemresouce database and look at the source for sys.server_principals and saw where they're restricting (using the function has_access) what rows...

Agreed. Topics (the whole thread) as well as just a specific message within a thread.

I'm interested in seeing how MS gets the data returned by particular views and functions/procedures. In 2000 I needed a view that would return user information from syslogins but...

the maximum memory "limit" only applies to some of MSSQL's use of memory. I have a server with 8GB memory and I'd set it to something like 6GB max...

my 2005 also gave the error, matching the "correct" answer. 9.0.3073 (SP2) 64-bit and 9.0.3310 (SP2 w/CU11) 32-bit

EDIT: On both versions I only got the error message. ...

*Sigh* Except the scripted results may not be usable. For example, I scripted sys.server_principals and the resulting Create script shows it selecting from master.sys.sysxlgns which I can't find...