How can I import a DTS file to a new SQL Server?
Is there any feature in SQL2K that I can use.
execute as sysadmin sp_changeobjectowner objectname
I heard this will be available in Yukon,...
Is there any way I can Sync Users two DB.
I want to take a backup from my production server and restore in to a Development Server. The issues is...
I have a char filed that get entered a combination of Char and Nubers.
but some where in the process in gets...
I am trying to convert a date formats:<br />Date to MMDDYYYY<br />I know how to convert to YYYYMMDD as follows.<br />select (convert(char(<img...
I have SQL Server database.
Total database size is close to 15Gb.
The data file size is approximately 3.5 Gb, and set to Grow Automatically by 10%...
I want to eliminate hyphens, apostrophes,blanks,persods,suffixes(Jr.) or Perefixes (Dr.)from the below statement.
Wht would be the best way to...
Separate names with a comma.