I am trying to figure out how to set a column to null usin the Enterprise manager (EM).
In other words, when I right click on a table in the EM, and...
I see where my stored procedures are stored.
They have their own folder for those objects.
There is not a corresponding folder for triggers.
What is the difference between using an integer and a numeric data type?
Also, which is best for storing information such as social security...
Is there a minimum size of a column name in sql server?
When I create the new column it has brackets wrapped around the name.
What are the...
I need to disable a user's login after 90 days.
The userid and password are stored in a user table.
Any suggestions about how I might go about...
Is there a way to store email in a database table?
Also, how do I enable email to be sent from SQL Server?
What is the best datatype to use for storing phone numbers in SQL Server?
What are the reasons behind using a specific datatype?
I read somewhere...
If I want to detect the date a record was added to the database, do I have to create a trigger?
For instance, if I have a login table and I want to...
I am new to database administration.
What is involved in creating multiple environments?
Do I create a dev environment and then just copy to test,...
Separate names with a comma.