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...
During an Off peak time, backup your DB,
Run DBCC SHRINKDATABASE ('DBName', DesiredTRansLog Size in MB)
Example: SHRINKDATABASE ('PUBS', 10)
I have a char filed that get entered a combination of Char and Nubers.
but some where in the process in gets...
Thanks for the help.. Kudoos to all..
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 played around DBCC ShrinkFile and it worked.
I have backed up the TransLog, and ran the DBCC SHRINKFILE script.
I have tried your suggestion as follows
I have used the logical name. Still it didn't shrink to the that I want. I want to bring it...
DBCC SHRINKFILE (SERM_Log,500)
DBID FileID CurrentSize MinSize
Thanks, I am kind of new with this, so please check the below script before i execute.
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%...
Thanks Everyone for their inputs and suggestions..
I was able to get my results unsing the function that Twan suggested
I am kind of new with the SQL functions, so can you be little more specific?
As you can see my deafauly SQL statement and the outputs....
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.