Developer Newsgroups: SQL Server Tools

Maintenance Plan Log time stamps

Michelle - 11 May 2007 7:47 PM - 1 message

I have a simple Maintenance Plan, it does the integrity check and then a Backup. The Log reads as follows: Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'ServerA' as 'DOMAIN\ADMINUSER' (trusted) Starting maintenance plan UserDB Backup Maint Plan' on 5/10/2007 5:30:03 AM ...

Profiler replay with more than one DB

FredDBA - 11 May 2007 5:59 PM - 1 message

Hi, in order to reproduce the production workload I am trying to use the replay trace functionality of the profiler v.2005. I did everything the doc says, same dbid, same logins/users/passes, use the traceSQL template, etc.. ...

Profiler replay option

FredDBA - 11 May 2007 5:58 PM - 1 message

using SQL Server 2005 profiler, I would like to simunlate the Prod activity into another server. It seems that when I replay the logs it goes all the way down "as fast as possible" without regards of the timing. Let's say I trace 3 queries with a 30 secs ...

SQL Server 2K transaction log

Egghead - 11 May 2007 2:54 PM - 5 messages

Hi here, I am a developer, not DBA, and we need to develop an in-house tool to update database records at remote site. I understand we can use replication. However, it does not work as we like and does not suit our need. Therefore, ...

SqlWb.exe and BOSD

Srini - 10 May 2007 8:55 PM - 2 messages

I have been getting this BOSD whenever I used SQL Management studio to open a table. The table in question has about 4 rows. I have reinstalled SQL 2005 and applied SP2. Still no avail... The machine is a very decent lenovo Z61t and has about a GIG of memory in ...

Export dates to CSV

Vik - 10 May 2007 8:16 PM - 2 messages

A table has a datetime column, which contains dates only (no time part). In EM, the dates look like 5/10/2007. After exporting the table to a CSV file using All Tasks->Export Data... the dates look like 2007-05-10 00:00:00. ...

Reporting Services error

Dan - 10 May 2007 7:32 PM - 1 message

I am running Reporting Services 2000 on a Windows 2003 server. When I try to run reports, I get this error: Failed to load expression host assembly. Details: StrongName cannot have an empty string for the assembly name. If I change my virtual IIS directories to ASP.net v1, I get application ...

Using Profiler in SQL 2005 Express

Clyde - 10 May 2007 7:23 PM - 1 message

I am installing SQL 2005 express on a couple client systems that will not be accessable from a central SQL 2005 Standard instance. Is it possible to install and run profiler and query analyzer on each client instead of from a ...

Copy SQL Server 2005 Express database to SQL Server 2000

Angus - 10 May 2007 5:44 PM - 5 messages

Hello I have a copy of a SQL Server 2005 Express database - the mdf and .ldf files. If I copy to my machine and in the Enterprise manager try to attach the files I get error 602 - and apparently you cannot do this as the ...

Error installing SQL Server Developer 2005

Mervin Williams - 10 May 2007 5:36 PM - 4 messages

I'm trying to install Microsoft SQL Server 2005 Developer Edition and each time I attempt to I get the error message: "Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll ...

?? Restoring a BAK -- Do I Need the Schema ??

Alan Foxmore - 10 May 2007 2:50 PM - 7 messages

Hello everyone, I'm new to SQL Server 2005. I'm using the Express version. A co-worker sent me a BAK file which I need to restore. My question is, do I need to have the database structure already in place before I can do the ...

transfer tables between databases with only client components

Dean g - 10 May 2007 10:37 AM - 1 message

Sorry if this is a silly question i'm fairly new to sql server. I usually use query anaylser to transfer tables across databases. Unfortunately i can only access my database from a vps which only has mssql server client components installed. ...

SQL Profiler and Import Performance Data

Rotsey - 10 May 2007 6:52 AM - 2 messages

Hi, I am using SQL Profiler for SQL 2005. I have opened a trace file and i want to import a performance data file but the "Import Performance Data..." menu option is disabled. Any one know why?? I googled but not a single reference found. ...

SQL Server 2000 and Reporting services

Kal - 9 May 2007 5:40 PM - 2 messages

Hello, Our IT department just installed SQL Server 2000 on a Windows 2003 machine. I am trying to find out how I can get SQL Server Reporting Services, I think it would help me with some metrics that I have ...

SQL2k5 maint subplan wont delete completely

Steve M - 8 May 2007 4:49 PM - 1 message

I created a maint plan in SQL2k5. I then needed to duplicate the plan, so I scripted the jobs, changed the names, and ran the script. I then needed to delete some of the maint plans. I deleted the plans, and the jobs didn't ...

Modify Records In Results Window

Robert - 7 May 2007 2:26 PM - 2 messages

Hello, In earlier versions of SQL, I could use Enterprise Manager to modify or delete records from the pane that was displayed when I right-clicked a table and chose "Open Table Return All Rows" or "Open Table Query". With the new ...

Backup job failed-SVP2

Peter Lux - 7 May 2007 2:06 PM - 7 messages

I have a job that has run fine for quite a while now. It backs up db and trans logs file and then deletes bak and log files older than 2 days. I noticed that since 4/23/07, it hadn't deleted the bak files nor the trans ...