SQL Server Tools - Week 12, 2006

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) ...

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? ...

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 ...

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 ...