Hi

If you want special characters , lenght etc in passwords you are better off using Windows authentication. You can have mixed mode as your authentication mode but the users connecting...

Hi

Do you have anything other than the normal "things" in the db. Any image , Varchar(MAX)... columns. Any encryption or anything else that could give a clue on this.

Hi

Can u make your question clear? Do u mean text columns?

Pls Keep us posted.

Hi

I dont think there is any configuration that allows you to restrict the number of connections per db.

How ever you can check for who are connected to a db...

Hi

First get the vendor to check what is the exact reason why the app is going slow. Is it the coding, cursor, locking etc.

Find out the reason and then solve...

Hi

You will have to use "Case" statements for this.

Iam not up to writing the statement for you now... Sorry abt that. Search this site and you will find many...

You can also check sql server logs for db craetion.

Hi

Seems like SQL Server is facing memory restrictions. Some points that i can think of...

Is your database very large and are you working with large datasets. Do you have a...

Hi

Do you want all users to connect to connect to a single database or only one user to connect to a database?

Why do you need this restrinctions in the first...

Hi

sys.dm_exec_sql_text is not a table, its a function. It requires a sql_handle as a parameter to display the sql text.

This sql_handle is got from sys.dm_exec_query_stats.

Hi

You wont find all the things u want in one table.

check out these DMV's - sys.dm_exec_query_stats , sys.dm_exec_cached_plans, sys.dm_exec_sql_text, sys.dm_tran_locks , sys.dm_exec_sessions .

Hi

GETDATE() is a function and even when u say select getdate() it will return the current datetime value.

Check out the DynamicManagementViews (DMV) in BOL for all the info that u...

Hi

So what do we do when the questions go wrong. Can the points be given to people who have chosen the "RIGHT" answer.

Hi

You can use bulk insert on a database which is in simple recovery mode. Recovery models define how much the data can be recovered in case of disasters.

Read up...