Run that query from a query window. I think you'll find it returns more than one result set, and that's why your task is failing.

John

You've got three options, in ascending order of preferability:

(1) Use dynamic SQL

(2) Search this site for "splitter function" and use that two break your input string into a set of...

James, please will you elaborate on this? Are there any error messages, for example?

Also, using UPDATE FROM will give unexpected...

Sanjeev

I don't know of any way of deleting other people's temp tables. I tried it once, without success. Even if there is a way, the best option is...

v.sreelekha (6/30/2011)

---

How can we execute a sql query inside a dataflow by passing dataflow variables as input parameters to the query?

I want to execute this query in some data flow...

MG Chowdary (6/26/2011)

---

i denied select for public because the default public role has read perms on all objects so to avoid new users from selecting data i denied select on...

Also, how do you run the stored procedure? In other words, please give an example of what parameters you pass to it.

Thanks

John

Ah yes, good shout. Try this:

USE <InsertYourDBNameHere>

SELECT groupid, name, filename, size * 8.0/1024/1024 AS file_size

FROM sysfiles

John

OK, let's try this a different way. Please run this and post the results:

USE <InsertYourDBNameHere>

SELECT type_desc, name, physical_name, size * 8.0/1024/1024 AS file_size

FROM sys.database_files

Thanks

John

Sorry,...

OK, the only way to guarantee you get the same order is by putting ORDER BY datum at the end of all your SELECT statements.

John

Is your database in Full recovery mode or Simple? If Full, how often do you back up your transaction log? How much of the 135GB is data file(s)...

The sys.sql_modules system view contains the full definitions for all functions and procedures. You can look for each table name in the command or definition column (I can't remember...

It's not about percentages - it's about how much free space you have in your database. There are different rules for how much space will be released from data...

Unless you use an ORDER BY clause, SQL Server will return the rows in whichever order it deems most expeditious. Often that will be in the order of the...