Developer Newsgroups: SQL Server Tools

Autoimport from xls to SQL 2000?

Cwhitmore - 16 Feb 2007 10:18 PM - 2 messages

I have a program setup the exports check request data into a xls file every week on a shared directory on Windows 2003 server. I'd like a way to import that data into SQL 2000 on a weekly basis. (Shared directory and SQL on same ...

Management Studio

vovan - 16 Feb 2007 8:54 PM - 4 messages

One of my client installed SQL Server 2005 from Small Business Server package. I cannot find Management Studio there. We tried to add it via reinstallation, checked SQL Tools which includes MS, but after several seconds we got a message that nothing was changed and due to that nothing ...

sp_trace_setfilter does not work

Quinn - 16 Feb 2007 5:17 PM - 5 messages

I am trying to create a server side trace via script. The trace will have a filter on LoginName. However the trace is created but the filter is not there. I used to do this all the time under SQL 2000 but I have not been ...

SQL Server Database display a image

jeff - 16 Feb 2007 3:10 PM - 3 messages

Hi All, I have a column has hold a image binary, When I browser on query analyzer? I want to display as an image? Can I do that ? how to do it? Any suggestion would be great help. Thanks ...

Tool to create link between multiple databases

yanky - 16 Feb 2007 2:25 PM - 2 messages

We have 4 different databases, each with one or two company/contact tables of its own. We are looking for a tool to 'run' thru the tables(say company) and create a seperate table with all the linkage. We are looking to match on phone, address, company name. I know we ...

create a new instance

--== Alain ==-- - 16 Feb 2007 9:02 AM - 4 messages

Hi, How in MS SQL 2005 create a new instance, without reinstalling MS SQL 2005 ? for example i have the default instance SQLEXPRESS and now, for 1 software need, i must create a new instance called "magiceye", how can i ...

Can SQL 2000 Enterprise Manager & SQL 2005 Mgnt Studio coexist ?

Johnny - 16 Feb 2007 4:50 AM - 3 messages

Hi, I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC. I would like to install SQL 2005 native client (Mgnt Studio etc) on the same PC. Can they be coexisted and both can be used ? OR ...

? on xp_sqlmaint and the -Rpt option

JoeyD - 15 Feb 2007 7:01 PM - 1 message

I'd like to know if there is an internal (to xp_sqlmaint) limit on the length of the input parameter for the -Rpt option? We have a procedure that we use for our backups that have worked for several years with out any problems. Recently however, and SharePoint ...

SSMS: Event Notifications: Where are they?

Hawkins, Charles F. - 15 Feb 2007 6:32 PM - 3 messages

Maybe I'm just overlooking them. Can you see event notifications in SQL Server Management Studio? ...

Recommendations for SQL Server-compatible database design tool?

Oenone - 15 Feb 2007 9:49 AM - 3 messages

Can anyone recommend a utility (preferably free but can pay if needed) that will allow me to easily design database structures (tables, indexes, relationships) for SQL Server? I have a couple of specific requirements for it: - must be able to store its designs in an accessible format (e.g., XML) so ...

BOL (2005) Favorites

Michael MacGregor - 14 Feb 2007 9:57 PM - 3 messages

Not sure if this is the right place to ask this but here goes anyway, and I'm sure if it's the wrong place, someone will soon tell me. I have a whole bunch of items in my favorite list in BOL (SQL 2005) and ...

SQL Server Job Opportunity

drew.wall@gmail.com - 14 Feb 2007 7:08 PM - 1 message

Hello everyone, I am a technical recruiter for SD3 ( [link] ), an IT company in the Chicago area. I have exhausted the job boards ...

Fickle Import Performance Data... for profiler 2005

John T - 13 Feb 2007 6:35 PM - 3 messages

Hello, I'm doing a client side trace using profiler 2005. Concurrently I'm collecting sysmon logs stored to csv file, from the same client workstation. The client workstation runs the SQL Server Management Studio client utility, and Perfmon. The server I'm collecting data from runs SQL Server 2000 sp4, ...

SSMS Warning Message on vssettings

HenryT - 13 Feb 2007 5:58 PM - 1 message

Each time I load of quit SQL Server Management Studio I receive a warning message which says "The automatically saved settings file 'd:\SQL Server Management Studio\Settings\CurrentSettings-2006-11-06.vssettings' cannot be found. You can change this file on the 'Import and Export' Tools Options ...

Stored procedure debugging

Dave Patrick - 12 Feb 2007 11:26 PM - 7 messages

Is there any native tools for simple step mode through a purely TSQL procedure? I'm rather new to stored procedures. I've managed to figure this out with query analyzer 2000 but haven't figured out what to use with SQL ...

Profiler: SQL:StmtRecompile - EvenSubClass definitions?

Michael MacGregor - 12 Feb 2007 3:47 PM - 6 messages

Hi Everyone, I have been monitoring recompiles, and am seeing different EventSubClasses for these, but have been unable to find any further details about the various EventSubClasses in BOL. Can anyone direct me to more detailed descriptions/definitions about these? ...

Urgent: MS-BI (SQL Server 2005-AS/RS/IS)-CMM 5-Hyderabad (with possible onsite)

WI Projects - 12 Feb 2007 8:57 AM - 1 message

Hi, A CMM Level 5 company is looking for Microsoft Business Intelligence (MS BI) professionals for its Hyderabad location. There is a an element of onsite travel & work to this position. Please keep the following points in mind before mailing your CV. ...