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...

Why have you posted this question in two places? You won't get an answer any quicker.

Original thread here:

http://www.sqlservercentral.com/Forums/Topic1130242-357-1.aspx

Kahn

Back up to a separate drive, across the network to a separate server, or direct to tape - whichever works best for you. But don't have your backups on...

srinath.vanama (6/23/2011)

---

Hi,

This is not at all a problem, if there is a free disk space u can un-restrict the file growth of .mdf, and restrict the file growth of .ndf...

JV

No, it's not a problem, unless, for instance, you have lots of free space in one that is stopping the other from growing. Yes, you can merge them into...