Developer Newsgroups: SQL Server Tools

SQL Insert Character Limitation

AJ - 2 Jun 2006 2:12 PM - 4 messages

What is the limitation for the characters allowed in a SQL insert statement or what is the limitation to the amount of characters that can be inserted into a column from an insert statement? ...

Transact Log truncate

Hitesh Joshi - 2 Jun 2006 2:11 PM - 7 messages

Hi, I have a MS SQL 2000 server database with gazzzzzillion rows. Last night I backed up lot of the data and deleted it from the database to clean it. After deleting data from the database, I did full backup and ...

ANN : myLittleAdmin for SQL Server 2005

el.c. - myLittleTools.net - 2 Jun 2006 8:17 AM - 1 message

June 1st, 2006 Company: myLittleTools.net Contact: Elian Chrebor Email: el***@mylittletools.net Paris, France myLittleTools is very proud to announce myLittleAdmin for SQL Server 2005, the first web-based management tool specially designed for SQL Server 2005. It will be officially launched on June 8th, 2006. ...

how to get particular record from database , not mentioning table name?

SSG - 2 Jun 2006 5:09 AM - 2 messages

Hai All! I am new to database ... I have One databse having 10 tables in sql server. I stored data in differnt table using city wise. If I Give the "Code Num " it should tell me the city name, I dont know ...

Edit/Modify Stored Procedure in Management Console 2005

Jim Little - 2 Jun 2006 2:27 AM - 14 messages

I hope this post spares other the heartache I experienced. I have seen many posts where someone who was familiar with SQL Enterprise Manager is asking how to modify a stored procedure in the new SQL Server Management Studio 2005 (SSMS) tool--and the responses are cryptic and ...

Unable to see backup files

KenL - 1 Jun 2006 2:15 PM - 4 messages

I am using SQL Server 2005 Standard Edition running on Server 2003 Standard. Using Sever Management Console, loading the "Locate Backup File" dialog in the process of restoring a database from device on the "Restore database" dialog, I am not able to see all the backup files that exist in the folders. ...

SQL2K5 Groups Question

Mike C# - 1 Jun 2006 3:27 AM - 5 messages

Just wondering if it's just me, but 99 out of 100 times when I try to post to the SQL 2005 forums my message just won't go... I was just wondering if anyone has encountered this and if there's a simple configuration setting I ...

SQL Creator Question

Adrian - 31 May 2006 10:15 PM - 2 messages

I have installed the Snefru SQL Creator and have to specify a JDBC driver. I am using SQL Express. Could someone please tell me the file location? Many thanks, Adrian. ...

Enterprise Manager crashed and now won't open

SherryB - 31 May 2006 9:31 PM - 2 messages

This is on a WinXP Pro machine that only has the Server Tools for SQL2000 installed. The user had a problem in an Access database while SQL Enterprise Manager was still open but idle. It locked up her machine so that she had to ...

Backup Using SMO

Lee - 31 May 2006 7:54 PM - 6 messages

I am trying to use SMO to backup a complete database to a File. However I do not see any where within the Backup or Database obejcts to indicate where I want the backup placed and what the file should be named. What's the trick? ...

ANN: Context Database Designer v.2.05 is now available!

Context Software - 31 May 2006 1:56 PM - 1 message

Dear Friends, We are happy to announce the new release of Context Database Designer & Database Extensions v.2.05. Both products are immediately available for download at: [link] and ...

SQLCMD "-r" option (SQL 2K5)

Mike C# - 31 May 2006 12:07 AM - 4 messages

OK, so I'm playing with SQLCMD and trying to get the "-r" option to work. According to BOL it's supposed to redirect error messages of severity level 17 or higher to the screen (stderr). Presumably this would be useful in ...

Using Query Analyzer with SQL 2005

Richard West - 30 May 2006 9:50 PM - 12 messages

I'm about to install and roll out SQL Server 2005. One question that I have though: Can I still use Query Analyzer with SQL Server 2005? I really like how simple the interface is to do quick and dirty ad-hoc ...

SQLCMD and System Views Problem (SQL 2005)

Mike C# - 29 May 2006 12:13 AM - 2 messages

Hi all, Having a problem SELECTing from the system views in SQLCMD interactive mode. All other functionality appears normal, but the following query does not work in SQLCMD: SELECT * FROM sys.tables; I get the following message: Msg 208, Level 16, State 1, Server SQL2005, Line 1 ...

database log truncated, transaction log backup job failed

Gilbert - 28 May 2006 4:28 AM - 8 messages

I am running Sql 2000 SP4 and I have a Database maintenance plan setup to run an integrity check, perform a backup of the database and a transaction log backup. The integrity check and database backups are successful. The transaction ...

SQL Agent Job/Alter

ybc - 28 May 2006 1:01 AM - 1 message

Hi, Iâ€™d like to use SQL Server 2003 to setup a job/alter to execute a SQL query like: â€œSELE code from stock WHERE date=getdate()â€ The result is sent by SQL mail. The SQLAgentMail is setup and works. ...