So far we only three or four schema per database. We manage our security through a role in the database. The roles get access to stored procedures. The stored procedures...

BOHICA

:w00t:

To my knowledge, not using this quick way of scripting. If you do an actual export to file you get the option of having a single file or seperate files...

I'm not sure what you mean. We're not talking about tables, but about stored procedures. If you have a data type of int in the stored procedure, the character length...

This isn't documented, but does what you want:

exec sp_procedure_params_rowset 'procname'

The -1 returned by the view is the designed method. The procedure, in my mind, is worse. It shows a length...

Personally, I use autogrow. But, I recognize that it is a crutch. I spend a lot of time & effort in setting up monitoring so that I know how much...

SELECT * FROM INFORMATION_SCHEMA.PARAMETERS

WHERE SPECIFIC_NAME = 'myproc'

That'll get you exactly what you want

I agree, if you have no information on anticipated load, etc., about 25% of the initial data size would be a prudent number.

However, I'd make sure I had a more...

Just remember that short-hand notation like BTW, OTOH, IIRC, are for very informal communication. You can use them on line, but you wouldn't want them in formal documentation, requests for...

PASS is the Professional Association for SQL Server. They have an annual get together called the PASS Summit. This year it will be in November in Seattle. They also have...

You want to take a look at the catalog views, like sys.database_files which will give you hard information about the files themselves, or dynamic management views, like sys.dm_db_file_space_usage which will...

Because we like our data

😀

More detail would be needed to provide useful answers. Does merge mean two identical structures but different data, two completely different structures but similar data, two totally different structures and...

We've gone both ways. If you do leave the hyperthreading on, you can't treat it like a real multi-core machine. So for example we have two processor machines with hyperthreading,...

What about using a SCHEMA? Then you'd see the list like this:

Module1.Table1

Module2.Table2

Etc. Then you can use the Filter function in SSMS to only display the schema that you're interested in.

Another...