Search Results | SQL Server Performance Forums

Import DTS File

Thread by: vpathisseril, Jul 7, 2005, 1 replies, in forum: SQL Server DTS-Related Questions

How can I import a DTS file to a new SQL Server?

Execute as.

Thread by: vpathisseril, Oct 7, 2004, 3 replies, in forum: T-SQL Performance Tuning for Developers

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,...

Sync or Create New logins

Thread by: vpathisseril, Nov 20, 2003, 2 replies, in forum: General DBA Questions

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...

Conversion

Thread by: vpathisseril, Oct 30, 2003, 5 replies, in forum: General Developer Questions

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...

Convert Date Format

Thread by: vpathisseril, Oct 29, 2003, 4 replies, in forum: General Developer Questions

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...

Reduce the Tran's Log size

Thread by: vpathisseril, Oct 22, 2003, 17 replies, in forum: Performance Tuning for DBAs

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%...

Help to eliminate some chars

Thread by: vpathisseril, Oct 17, 2003, 7 replies, in forum: General Developer Questions

I want to eliminate hyphens, apostrophes,blanks,persods,suffixes(Jr.) or Perefixes (Dr.)from the below statement. Wht would be the best way to...