Developer Newsgroups: SQL Server Tools

View Image

Esha - 23 Nov 2006 3:22 PM - 6 messages

I have a field of Image type in several tables in SQL Server 2000. Data was transferred from Access db awhile ago. In Access there is a way to see the image in OLE Object type column (right click on the field, then Bitmap Image Object, then Open. Paint starts ...

Common Objects in SQL Server 2005

Dio - 23 Nov 2006 11:34 AM - 4 messages

Hi, please tell me where I can find Common Objects in SQL Server 2005.....that who appear in Query Analizer (SQL Server 2000) Common Objects: Configuration Functions, Cursor Functions, Date and Time Functions etc Thanks a lot ...

Copy/Paste behavior in SSMS

wgbrown - 21 Nov 2006 9:59 PM - 7 messages

I realize that this seems odd, but I want to change the copy paste behavior in SSMS. Right now if you have no text selected in SSMS and do a control-c the entire line is copied, but I want the copy to be null. Basicly I'm ...

Backup troubles

George Spiro - 21 Nov 2006 9:01 PM - 4 messages

Hi, I need some help with a logic for a important document I need to create. Its regarding my Backup procedures that require me to test my database backups every 3 months. The problem occurs that I do not have another server to test ...

Beta testing a cross database integrity tool for SQL Server

Tom - 21 Nov 2006 3:09 PM - 1 message

Hi, We are in search of beta testers for our new software tool for SQL Server : Remote Keys allows you to define and enforce cross databases integrity constraint. With Remote Keys, you can create a foreign key between to SQL ...

Running Backup through Maintenance Plan

Andrew Harlan - 21 Nov 2006 2:57 PM - 2 messages

I am receiving an Event 208 when running our autmated backup in Enterprise Manager. The job use to run fine however possibly a change in password caused this to stop working? The error states: Event Type: Warning ...

Scheduling backups of a remote SQL Server 2005 database to a local file without using Management Stu

Debbie Croft - 21 Nov 2006 8:30 AM - 2 messages

I'd like to find a tool that will automatically (at set periods) back up a remote database to a (local) file on my desktop computer - and restore it, if necessary, obviously. I can't install any new software on the server. I don't want to install SQL ...

2000 Enterprise Manager vs. 2005

gsengstock - 20 Nov 2006 9:32 PM - 6 messages

Though most of the changes we might be able to get used to, there is one super annoying change we have not found the equivalent to: What is the equivalent of using the 2000 EM Right-Click--->Open--->Query method in 2005 ES? That was always the ...

BCP Invalid character value

John Oberlin - 20 Nov 2006 5:53 PM - 2 messages

I am getting a 'Invalid character value for cast specification' error when trying to BCP data from a SQL 8.00.760 instance to a SQL 9.00.2047 instance. BCP out syntax... exec master..xp_cmdshell 'BCP database..table in D:\Temp\database\table.txt ...

user / security migration

Pablo Cognito - 20 Nov 2006 10:29 AM - 2 messages

Hi, 1) is there a migration tool for migrating users from ss2000 --> ss2005? What about security on databases? 2) is there a migration tool for migrating jobs made in ss2000 --> ss2005? ...

Eventlog Warning reg SQL Tools 2005

patsql - 20 Nov 2006 2:11 AM - 4 messages

I installed SQL Server 2005 with SQL tools on a Windows 2000 platform, and get the following warning every 20-30 seconds. Source is MSIInstaller, and user is ASPNET. I reinstalled the SQL Tools, to no avail. I do not have any functional ...

Anyone using Quest tools ?

Hassan - 20 Nov 2006 2:09 AM - 2 messages

And if so, any pros and cons ? I have heard that Spotlight can be an overkill on OLTP applications. Let me know.. ...