How can I import a DTS file to a new SQL Server?
Is there any feature in SQL2K that I can use. Example.. execute as sysadmin sp_changeobjectowner objectname I heard this will be available in Yukon,...
Hi, 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) Backup...
I have a char filed that get entered a combination of Char and Nubers. EXAMPLE: FiledName (CHKNO) TTSC01234, 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...
Hi.. Thanks Satya.. I played around DBCC ShrinkFile and it worked. I have backed up the TransLog, and ran the DBCC SHRINKFILE script. Repeated the...
Thanks Satya, 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 102781680 128781680128
Hi Satya, Thanks, I am kind of new with this, so please check the below script before i execute. http://goEdeveloper.com/work F:SQL Serve...
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
Thanks Twan, 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.
