Developer Newsgroups: SQL Server Tools

Can't see Mapped Drives in Database Maintenance tool!

Infomax - 11 Nov 2006 4:21 AM - 2 messages

I have SQL2000 & SQL2005 running on Windows 2003 servers. I am using the Database Maintenance tool to backup selected databases. I realized the only drives I can save these backups to are the local drives. We don't have enough space on these local drives, so is there anyway to see the ...

Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database, Line 46 Full-Text Search is not

AngelEyes - 11 Nov 2006 1:23 AM - 2 messages

I have SQL Server on my webserver. The version of SQL Server and My Operating System, which I have got from the query "Select @@version" is Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 ...

How do i find indexes of the columns in SQL server 2000???

frien - 10 Nov 2006 10:01 PM - 3 messages

How do i find indexes of the columns of all the tables of the datbase...........most importantly in SQL server 2000 Thanks a lot ...

Database synchronization question

segis bata - 10 Nov 2006 4:42 PM - 4 messages

Hello everyone, I'm going to copy all the tables from one database in one server to other database in another server. A couple of days later I will want to copy the new (and updated) records (from those couple of days) instead of copying ...

Template Explorer Reorder Folders

Babe - 10 Nov 2006 3:21 PM - 3 messages

Hi, I have created a new folder in my Template Explorer Window. It appears at the bottom of the tree. I would like to reorder the list so that folders appear from A to Z. I don't seem to find anything about it. ...

Debugging Stored Procedures

John Nolan - 9 Nov 2006 4:14 PM - 6 messages

Hello, I've recently upgraded to SQL2005 standard edition and I'm struggling to find how to debug stored procedures. I fire up the accompanying Visual Studio and goog-ahem MSN search suggests that I need to start up a Database ...

SQL 2005 PERFORMANCE

Jay - 9 Nov 2006 12:52 PM - 3 messages

Hi, We are working with SQL 2005 64 Bit server, with 16GB Ram, now our database size is going 16 Gb, but our server performance is very poor, I setted Min memory to 1024 MB and Max memory to 14 GB, now my page File usage showing ...

install Performance Tools

SteelMillDon - 9 Nov 2006 10:24 AM - 10 messages

Hi, I have looked for some time now and I cannot see how to install the Performance Tools in a pre installed SQL Server 20005. How do I go about this? ...

SQL 2005

WSW - 8 Nov 2006 9:40 PM - 5 messages

Does the 2005 SQL Server have anything built in to allow for administration of the server over the web? I know 2000 had the web admin tool. ...

Unknown Connection manager error

Phynortner - 8 Nov 2006 8:19 PM - 1 message

I am running into an error with one of the desktops using the Import wizard. When the user chooses Excel as the data source, it throws the Unknown connection manager error. I read about a similar problem in this group that the posting was in ...

WebMethod_doesn=B4t_show_up_in_WSDL

buki - 8 Nov 2006 4:45 PM - 1 message

Hi, I created a service sndpoint with the following script (which worked fine): CREATE ENDPOINT SpDocSearch STATE = STARTED AS HTTP ( PATH = '/SpDocSearchWebService', PORTS = (CLEAR), AUTHENTICATION = (INTEGRATED ) ) FOR SOAP( WEBMETHOD 'QueryDocsDatabase' ( NAME = db.dbo.fn_SearchDocsFulltext' ...

Log Parser - Telephone call log analysis

Jarryd - 8 Nov 2006 3:07 PM - 5 messages

Hi, I have a PBX (telephone server, if you will) that dumps call log data (SMDR) out to a text file. I think it might even be CSV. It may even be able to send it out over IP. I wanted to be able to write new records from the text ...

SQL 2005 Management Studio can't edit text rows with > 4000 charac

asanford - 7 Nov 2006 3:53 PM - 11 messages

I cannot edit any rows in SQL Server 2005 Management Studio (SSMS) that have a text-type field that contains more than 4000 characters in it. If I try to edit such a row, I get an error saying "String or binary data would be ...

backup again

William Cheung - 7 Nov 2006 7:16 AM - 9 messages

Dear All, does sql2005(std.) have any tools for backup whole database to file for other Backup software backup? thx, William ...

backup

William Cheung - 7 Nov 2006 4:30 AM - 5 messages

Hi All, i want backup my SQL server (2005) but i do not have SQL agnet for backup can i use follow script to copy whole database file and backup this file with NTBackup? can it's backup be restore and work fine? pls advise. ...

Can't register SQL-DMO

jcw - 7 Nov 2006 4:00 AM - 4 messages

Hi, this is an old issue and i've searched for days. I have a vb6 app thats worked for years on a NT4/SQL7 server using the SQL7 client. We are finally moving out of mixed mode and upgraded the server to NT2003/SQL 2000. ...

SQL 2205, Profiler and Deadlocks

Michael MacGregor - 6 Nov 2006 9:42 PM - 15 messages

We are having trouble tracking down some deadlocks and so I decided to use the new event Lock: Deadlock Graph Event and I set the Events Extraction Settings to Save Deadlock XML events separately, which was the only option I ...

View 1 row at a time.

Belinda Chu - 6 Nov 2006 5:20 PM - 2 messages

Can I view 1 row at a time with column name on the left and data on the right instead of multiple rows horizontally? Thank you. ...

how to connect sql server to oracle

dev - 6 Nov 2006 1:55 PM - 7 messages

ha i am facing the problem that i am unable to connect sql server to oracle i have sqlserver in my system and oracle server is in remote i want to access that database with using DTS ...

Database recovery issue

mita - 5 Nov 2006 7:39 PM - 2 messages

Hi guys I am trying to open a database which is on a shared drive. The database is stored in the 'my network places'. Now when I try to copy the database into my hard disk, it says "sharing violation, file in use' whereas nobody else is ...

create maintenance plan failed

Gilbert - 5 Nov 2006 7:32 AM - 6 messages

I am running Windows Small Business server 2003 R2 and I've upgraded the Sharepoint from MSDE to SQL 2005. I'm trying to create a Database maintenance plan to backup the Sharepoint database but I'm getting an error ...