Search Results | SQL Server Performance Forums

how to convert timestamp to datetime value

Thread by: motioneye, Sep 9, 2005, 3 replies, in forum: General Developer Questions

Hi, Can I convert timestamp value to current time values? when I convert select CAST (0x00000000000067FB as datetime ) it giving me oudated values...

Migrate db and creating new file group

Thread by: motioneye, Aug 25, 2005, 1 replies, in forum: General DBA Questions

Hi, I would plan to migrate my db to another server, current configuration with only Primary & indexes file group exits in the db and now I want to...

error msg return Ambiguous column name

Thread by: motioneye, Aug 24, 2005, 6 replies, in forum: General DBA Questions

Hi, below is my sql statement that wil join and update the values, but it giving me error Ambiguous column name both table hold the same column...

Add/drop colum in repl DB

Thread by: motioneye, Jul 25, 2005, 5 replies, in forum: Performance Tuning for SQL Server Replication

Hi.. I would like to know what would be happen if I just simply add/drop the column in repld db??? Or If I have added extra tables/column in...

Error while setting up publisher

Thread by: motioneye, Jul 25, 2005, 7 replies, in forum: Performance Tuning for SQL Server Replication

Hi.. One more error prompt by windows during setting up the Publisher. Error 20028 The Distributor has not been installed correctly. Could not enable...

replication setup display error not valid path

Thread by: motioneye, Jul 24, 2005, 2 replies, in forum: Performance Tuning for SQL Server Replication

Hi.. I'm trying to setup the replication distribution database. In specify Snapshot folder windows, it giving me error my path/folder 'Is not a...

Db Backup job failed

Thread by: motioneye, Jun 20, 2005, 7 replies, in forum: General DBA Questions

Hi.. I did run my Db full backup for everyday, the jobs shown failed, but the backup file was created. I did checked in the backup job history and...