Developer Newsgroups: SQL Server Tools

Install MS SSMEE without having SQL Server on computer?

Noozer - 22 Apr 2006 1:45 AM - 2 messages

I need to administer a remote MS SQL server. MS SQL Server Manager Express Edition won't install on my client PC because MSSQL server is not installed. Is there an app that I can install to administer the remote server? ...

SSIS: rocket science or dummy user?

herbert - 21 Apr 2006 8:53 PM - 2 messages

Every now and then I consider SSIS / DTS for a task like this: â€œHere is a MS-Excel file. A secretary recorded eBay auctions over years in it. It is not normalized containing the columns article number, auction number, description, date/time, and price. There is one MS-Excel sheet per ...

Copy users between databases

Terry - 21 Apr 2006 3:35 PM - 2 messages

Hello All, I used DTS to copy one database to a blank database for a backup of the database. A duplicate database. How do I copy over the user logins to the new database. This did not happen with DTS. ...

How to allow normal user (not Administrator) deployment of SSAS Cube?

Andrey Belkin - 21 Apr 2006 12:00 PM - 1 message

Hello, how to allow normal user (not Administrator) deployment of SSAS Cube? It says always that normal user cannot create new objects. Andrey. ...

SQLH2

shawn.dba - 21 Apr 2006 7:34 AM - 3 messages

I'm having issues with my SQLH2.PerfCollector not grabbing info for Avg.DiskQueueLength from my prodSQLservers. Null data for over 50 servers. All other data seems to be collected properly, and there are no related errors in the gather logs. I read somewhere that you have to run 'diskperf' ...

Solution to a Read80Trace failure

donald.ferguson - 21 Apr 2006 12:32 AM - 1 message

I was having a problem with the Read80Trace tool which is available through [link] The error I was receiving was OSTRESS returned an error code of -1073741819. A profiler trace revieled that the last statement performed by OSTRESS ...

A UNC Path in the backup location?

TJ - 20 Apr 2006 9:04 PM - 2 messages

Hi, Environment : Win Svr 2003/SQL Svr 2000 As far as I know, to specify a UNC path for backup location, MSSQLServer service should be running with an account that can access network resources... As you know, by default, SQL Svr 2000 is installed with LocalSystem account. ...

SQL 2005 Flat File source (in Import wizard) missing

Bob Feller - 20 Apr 2006 5:31 PM - 8 messages

SQL2005 Developer on XP SP2 MDAC 2.8 SP1 does not list the Flat File source in the Import wizard. Does anyone know how to get Flat File support? We've re-installed SQL2005, MDAC, SP2, to no avail. ...

Backup directory disappeared

FJC - 20 Apr 2006 1:54 AM - 1 message

Hi, For some reason the backup directory disappeared yesterday. Has anyone experienced the same? I'm running SQL 2000 EE over Windows 2000 Server ...

What's the best way to keep a live db and an archive db?

0to60 - 19 Apr 2006 8:03 PM - 8 messages

I have a live, production db that I'd like to keep lean and mean for performance reasons. Every so often, I'll run a cleanup script to scrub out some older data in order to keep the tables from growing indefinitely and ...

Displaying parms in Profiler when using DSN

Eric - 19 Apr 2006 5:49 PM - 4 messages

Hello, I am using SQL Server 2005 Profiler to troubleshoot a stored procedure. When I execute the SP using a normal SqlClient connection (in .NET code), it displays all parameters in Profiler as you would expect: EXEC usp_my_procedure 'myParameter' ...

[2005] Error screws up menu items

Jeff Johnson [MVP: VB] - 19 Apr 2006 4:26 PM - 2 messages

See if you can reproduce this issue: 1. Start Management Studio. 2. Enter a non-existent server name in the connection dialog and click Connect. 3. After it times out, click on the dropdown button at the bottom of the ...

How to avoid save prompts when

marcstober - 19 Apr 2006 3:14 PM - 2 messages

I'm enjoying the new SQL Server Management Studio and have set up some external tools (e.g., Perforce) to work with the Tools menu which is a nice shortcut. However, an annoyance is that whenever I try to run the ...

Define relationships on remote MS SQL server 2000?

Noozer - 19 Apr 2006 8:05 AM - 2 messages

Using Microsofts SQL Server Management Studio Express, is it possible to define relationships between tables? My database is hosted by my domain hosting company. I can connect to their server and modify my tables without an issue, but I can't see how to relate ...

Copy database from remote server to local?

Noozer - 19 Apr 2006 8:02 AM - 5 messages

My domain host hosts my MS SQL 2000 database. I am able to connect to it from my workstation using the MS SQL Server Management Studio Express application. I want to copy from the remote server, modify it, and upload it ...

How to Import and Export SQL Database???

fong01 - 19 Apr 2006 2:12 AM - 4 messages

Hi, I now is using MSSQL 2005 Standard Edition and MSSQL 2005 Express how can import an others database (like MSAccess, Foxpro, DB4 and etc.) and export sql database to others database? Have a tools like MSSQL 2000 DTS import/export data application??? ...

missing installation CDs

shefali - 18 Apr 2006 6:19 PM - 1 message

Hi, I had bought SQL Server 2000 Standard Edition a few years ago. So, I have a product key to use this product. I now need to install this on a new machine, but can't find my installation CDs. I called Microsoft to see if ...

SSMA - "Default Database is not accessible"

shearichard - 18 Apr 2006 12:58 AM - 2 messages

Hi - i'm trying to use SSMA to migrate from Oracle 10g. I don't yet have a full SQL Server environment so to test things out i'm using MSDE (the migration target is SQL Server 2000). I can connect to Oracle no problem but when i try to connect to MSDE I ...

Mob-ocracy and the Fall of the Republic

The Right Perspective - 17 Apr 2006 10:17 PM - 1 message

Are we fools? Or are we slaves? As in the film Gladiator, are we as a nation going from free men to slaves? Would we restore the Republic? Are we even still living in a Republic? Or a mob-ocracy? And where is our representation in ...

Repost: Need Help with "System.Data.SqlClient.Sqlerror: Cannot open backup device (DLT tape) ...

frostbb - 17 Apr 2006 8:57 PM - 1 message

We are having problems using the same DLT Tape to backup 2nd named Sql Server 2005 instance. Could really use some help. We have a Win2003 Enterprise Server (SP1) running two named instances of Sql Server 2005 (RTM) on the same physical server. ...

for sale: internetDotComs.com

internetDotComs.com - 16 Apr 2006 1:40 PM - 1 message

domain for sale: internetdotcoms.com [link] ...