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...
Thanks to both of you for the great info.
I see where my stored procedures are stored.
They have their own folder for those objects.
There is not a corresponding folder for triggers.
I will user sender instead of from.
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...
That seems to be what I need for storing the email.
Is there anything I need to do to enable SQL Server to send email alerts, etc?
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...
I think what I need for sending mail is really like an alert if something is wrong or scheduled?
Is there a way to store email in a database table?
Also, how do I enable email to be sent from SQL Server?
I found it in one of my searches for info on SQL Server.
Nevertheless, I did what you guys suggested.
I used varchar.
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...
Thanks for all the help.
I am sure the answer lies in between.
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 will definitely have the production separate from the other environments.
Can I have all my environments (dev, test, integeration) on the same...
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.