Developer Newsgroups: SQL Server Tools

External Tools - tried to save all my files

Catalin NASTAC - 24 Mar 2006 7:59 PM - 3 messages

I defined an "external tool" in SQL SMS 2005 to launck the notepad. Every time when I click it SMS tries to save all my pened windows (opened queryes - and I have a lots), asking me the save path and name. It's very weird. May I ...

Time stamp

MC - 24 Mar 2006 4:56 PM - 3 messages

How do you convert a time stamp into actual date in SQL When we try to convert it, date that we get doesn't make sense (date we supposed to get is like year 2001, but date seem to be very very old) ...

SQLXMLBulkLoad namespace problems

Christopher - 24 Mar 2006 2:50 PM - 1 message

I have problems using namespaces when using SQLXMLBulkLoad Starting from the example [link] part D. Bulk loading in identity type columns If the xml should be changed to <ROOT xmlns="http://tempuri.org/schema.xsd" > ...

Web Assistant

David - 24 Mar 2006 1:01 PM - 1 message

How can I back out of what the web assistant has created? I set up the web assistant andit worked fine for a while, now it's not working and nither is my program. I deleted the procedures, but that does not help, still not ...

Mysterious text in query result

BigMan2001 - 24 Mar 2006 11:22 AM - 2 messages

Hi, I have a database with a column defined as varchar(100) called Surname. When I use Query Analyzer to retrieve data from the column and display as text, I get strange text appearing for one of the records. Thus, the field ...

how to sort object explorer items?

frank - 23 Mar 2006 11:14 PM - 3 messages

Sqlserver 2005 Management Studio 'Object Explorer' lists servers, similar to Sqlserver 2000 Enterprise Manager. However, I can't find any way to sort object explorer's items? Also Enterprise Manager let you create folders to organize your registered servers; I can't find a way to do this in object ...

Query

MC - 23 Mar 2006 10:14 PM - 4 messages

Can someone help me for a SQL query to delete all the transactions from 2 SQL table? Here is what I want to do. "Go thru all the transactions in both table A and B If table A has a record, delete this record first, then delete the same ...

Query Analyzer Locking Up

Preacher Man - 22 Mar 2006 9:18 PM - 4 messages

I just installed client tools and when I use the QA it will hook up to the Database just fine, but if I go to the file menu, it locks up. Any ideas? ...

SQL Server Standard Management Console / Studio Not Available

thef150 - 22 Mar 2006 5:55 PM - 2 messages

I have tried several times using the SQL Server 2005 Standard DVD included at the "Ready to Launch" event to install SQL Server 2005. No matter what options I choose I never find the "Management Studio" installed. This was to replace the Enterprise Manager of SQL 2000. All ...

SqlSvrMgmtStudio and Sql 2000

Kyle Jedrusiak - 22 Mar 2006 4:59 PM - 2 messages

What are the best practices to get the complete database schema into VisualSourceSafe? Or at least point me in the right direction. Kyle Jedrusiak ...

urgent

Samuel Shulman - 22 Mar 2006 3:40 PM - 3 messages

I tried to copy stored procedure and some tables were deleted thank you ...

Microsoft SQL Server Management Studio

pd - 22 Mar 2006 9:07 AM - 2 messages

I have recently moved from a Microsoft SQL Server 2000 to a SQL Server 2005. In the good old Enterprise Manager, when I imported a table from a SQL server to another, I could choose "Copy objects and data between SQL ...

2005: How to install SQL-DMO samples (and DEVTOOLS folder)?

google - 22 Mar 2006 6:10 AM - 4 messages

Thiis really ticking me off..... How the heck do you get the SQL-DMO sample code installed from the 2005 installer? I have performed both full server and workstation installs with every option checked. According to BOL, under the topic "SQLDMO ...

MPS Deployment tool problem

Meena - 21 Mar 2006 10:25 PM - 1 message

Help! I am in the process of installing the (consolidated) hosted messaging solution. The MPS tool was fine until the step DWSPV.21; then all of a sudden it has trouble starting. As soon as I start, there is an exception saying ...

Management Studio: Project Hierarchy

YYZRic - 21 Mar 2006 6:43 PM - 3 messages

I created a project type "SQL Server Scripts" in "Microsoft SQL Server Management Studio", and the default structure created was: + Project Name + Connections (Type 2) ...

Urgent SQLDMO Version Problem

Lee - 21 Mar 2006 3:39 PM - 3 messages

I have a .Net app that uses SQLDMO to backup and restore databases for SQL Server 2000. The SQLDMO from my development machine is distributed with the application and is in the application directory, since the dll does not register using regsvr32 how will the app locate the DLL? For example I ...

PrimaryKey and unique

Michael Haberichter - 21 Mar 2006 3:24 PM - 2 messages

how can I design a table to get unique values in a column within the PK columns? Example: Client (int, PK) User (int, PK Userid(char...) userid's shoud be unique for a client. Other clients are allowed to have ...

How to detect diferences between 2 databases

JLobo - 21 Mar 2006 10:08 AM - 3 messages

I have a database B on server S and a database B1 o server S1 Is there any tool to give me the diferences between the two databases, new tables, new fields.... ...

Backup/Restore MSSQL database from domain host?

Noozer - 21 Mar 2006 5:49 AM - 2 messages

My domain host provides Windows hosting, including MS SQL database. Unfortunately it doesn't provide remote connections to their MS SQL server. I can see no method of retrieving my database structure, or the database populated with data, from the hosts control panel. ...

Parse a character seperated list of items

russ.haley - 20 Mar 2006 8:07 PM - 7 messages

Hey, Just spent WAY to long trying to parse out a item from a comma seperated list without using temp tables. I bet there is something out there already, but I couldn't find it. Here's my code for anyone that ...

Ink

mshawjr - 20 Mar 2006 12:27 PM - 1 message

Sorry guys. The spam stuff was not my intent. I do oppoligies and won't happen again. I have never been on newsgroups before and not sure how to work them. I hope you guys can forgive a bad choice. Murphey ...