Developer Newsgroups: SQL Server Tools

Anyway to automatical generate script to populated DB from Access

jerryk - 25 Aug 2006 11:09 PM - 2 messages

Hi, I am in the process of migrating an Access DB to SQL Server. We need to do this several times as part of the testing / deployment cycle. Right now we are manually running the Access upsizing Wizard, then running a script to ...

9003 The LSN %S_LSN passed to log scan in database '%.*ls' is inva

Cathy Soloway - 25 Aug 2006 8:21 PM - 3 messages

I recently tried to move 12 databases containing metadata for an application from a dev db farm (64-bit SP4) of SQL Server 2000. When I detached everything I got this error listed above. Luckily I could recover from ...

Customizing maintenance plan reporting in SQL2005

stavros - 25 Aug 2006 6:49 PM - 3 messages

I have maintenance plans set up in SQL2K that e-mail status reports to me upon completion. The e-mail subject lines have very handy formatting which includes the job name and final status, like "SQL Server DB Maintenance Report - SERVERNAME\System Backups (Success)". ...

Management Studio & Views containing unions

Stephan Steiner - 25 Aug 2006 9:11 AM - 2 messages

Hi I'm having a major beef with Management Studio Express when it comes to editing Views that contain a UNION statement. For starters, it can't display the View, which I guess is OK, the old tool couldn't do that either. But, ...

ANN: Context Database Designer & Extensions v.2.10 is now available!

Context Software - 24 Aug 2006 6:53 PM - 1 message

Dear Friends, We are happy to announce the new release of Context Database Designer & Database Extensions v.2.10. Context Database Designer & Extensions now supports: - MS SQL 2000/2005/Express - MS Access (NEW!) - My SQL 4 & 5 ...

Import Data succeeds but doesn't copy data?

geek-y-guy - 23 Aug 2006 9:22 PM - 8 messages

I have a dB on a remote SQL2000sp4/win2k server I'm trying to import into SQL2005x64 (sp1) on Server2003x64. I have a schema that I didn't write that created the database on both servers. During config on the import wizard I select to delete existing data and ...

ANSI Standards

Loren Z - 23 Aug 2006 5:08 PM - 6 messages

We are in the process of migrating our MS SQL Server 2000 databases to MS SQL Server 2005. We have using the MS Upgrade Advisor to flag problems in our databases so they can be fixed. Does there exist a tool from which we can get a report on ...

problem with db restore

Kamil Skup - 23 Aug 2006 3:48 PM - 4 messages

Hi, I've got file "database" without any extension. This file is a backup of database. On my computer I have SQL Server 2005 and i don't know what to do now with it. I tried to open it in SQL but it's no use. Then I have opened ...

Can Enterprise Manager be set to view Tables with NOLOCK?

John Kotuby - 23 Aug 2006 2:38 PM - 2 messages

We have a number of VB client/server customer installations of ours that use SQL Server 2000 for up to 50 desks. At times there are locking contention issues and we find that we can't view tables in EM to discern the nature of ...

SQL query problem -- Case or Join?

thabrown - 23 Aug 2006 2:23 PM - 3 messages

Hi, Sorry if I'm in the wrong group for this sql language question, but perhaps someone here can answer -- or direct me to a more appropriate newsgroup? I have a sql query that attempts to select a "DealerClientType" based on a ...

Debugging Stored Procedures with Query Analyzer

Stephan Zaubzer - 23 Aug 2006 2:21 PM - 4 messages

I have the following problem: When trying to debug a stored procedure with query analyzer it does not stop at the first line of code. Instead it runs throug the whole procedure and I cannot stop it! Am I missing something? ...

Partition recommendation in the Database Engine Tuning Advisor

Alex Petrovsky - 23 Aug 2006 11:13 AM - 4 messages

Hello, I have some problems with Database Engine Tuning Advisor. I can't find any partition recommendation. 1) I created a table containing two columns (int and char(16)) and filled it with simple data: 1, 'string' .... 2, 'string' .... 3, 'string' ...

Multiserver Administration SQL 2000

PetitGosaimass - 23 Aug 2006 10:56 AM - 1 message

Hello, I am trying to set up multiadministration server, since my company has 2 central cluster servers, with SQL Server 2000 SP3, and 80 local sql server 2000 SP3. I have recently upgraded a central to SP3, and did the same for a local sql ...

OSQL Batch File Problem

J. Baez - 22 Aug 2006 12:27 PM - 6 messages

I have a scheduled task that runs a batch file in windows 2003 server which is running SQL Server 2000 Enterprise. The batch file contains the line: OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log the 'myscript.sql' file updates a table with another table of the exact ...

Reading TRACE files in SQL 2000

Jan - 22 Aug 2006 10:46 AM - 2 messages

Hi all, I would like to write a stored procedure that starts automatically when SQL Server starts, and that logs certain events. I log to a trace file, and I enabled the failover file option: EXEC @rc = sp_trace_create @traceid OUTPUT ...

The Ultimate Bittorrent Cheat

RatioBoost - 22 Aug 2006 2:10 AM - 1 message

Auto Bittorrent Cheat is a Bittorrent client with a difference, It works just like any other Bittorrent client and is really easy to use, But it fakes your upload amounts to the tracker site in real time getting you a massive upload ratio & fastest possible download speed. ...

MS Access "Upsizing" Tools in SQL Server

Alex Maghen - 20 Aug 2006 3:56 PM - 9 messages

In SQL Server 2000 there was a feature for "upsizing" MS Access database files into SQL Server Databases. Is this still around in 2005? I can't find it and BOY do I need it. Alex ...

Bulk Insert

robpatt - 20 Aug 2006 1:48 PM - 3 messages

The file I am attempting to bulk insert has " " around all the text fields, Bulk Insert is trying to insert the double quotes with the text, and the error message says: Error: Bulk Insert fails. Column is too long in the data file for row ...