Good Morning Friends I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I have got one application developed by some software agency using VB 6.0 and sql server 7.0. Since last 6 years everything worked Three days my SQLserver machine crashed because of hard disk failure. Aft...more >>

I have two Windows Server 2003 servers. One is a domain controller and the other has SQL Server. The tape drive is in the domain controller. Am I OK with Backup Exec 10d for Windows Servers and a remote agent for SQL Server for Windows Server? Thanks ...more >>

I like SQL 2005 and it is nice that I can access pretty much everything from one location but I miss the light weight and and still a total work horse that QA was. Now, when I want to write a new query, I click on the New Query button and wait a few seconds for it to draw on the screen. I hate waiti...more >>

Hello, What is uniqueidentifier as a data type? Also what is the data type for setting unique STRINGS ((nchar, nvarchar), for example to be used for emails and user names in a user registration system). SQL Server does not allow me set primary keys for columns where data types are not IN...more >>

I'm authoring a .net webservice that connects to a SQLExpress database in the same project. When the code calls the database the following exception is thrown: "An attempt to attach an auto-named database for file C:\[...]\App_Data\App_Data\MyDatabase.mdf failed. A database with the same ...more >>

Hello, I was wondering if it was easy to migrate from SQL Server 2005 Express to SQL Server 2005 Standard? If so, do you know how I can go about doing the migration of data? Thank you. Sincerely, Eldhose Cyriac ...more >>

Hi, All We have sql2k sp4 databackup job writing dumps to a network backup box, failure due to "The specified network name is no longer available"? Following are the sql failure log. ANy ideas why it failed? That happens more often recently. The network is ok. I was able to map it. Is it pos...more >>

I am having a issue with a customers server. the specs are: 2003 server sql 6.5 log file size is 1998MB (customer increased this 2 times this week) Log space avail:600mb In EM i try and truncate the log file... but the free space never increases. Also there is no maint. plan on this databa...more >>

My goal is to have no downtime while rebuilding indexes. Since SQL 2005 doesn't support online indexing for tables with large object types (ie NTEXT), this is not an option for me. So I think the only other option is to use P2P replication.. Can I run ALTER INDEX REBUILD seperately on a live...more >>

Hi, I have char field that holds a value like '001' and I need to increment this char (like '002'). How can I do this? Thanks ...more >>

WHat is wrong with this. Says incorrect syntax near update and end SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER [Rental_Statustrig] ON [dbo].[Rental_Info] Update Rental_Info Set Rental_Status = (select job_status from Master where Master.wwpjo...more >>

Hi, I have come across a strange error and its the first time its ever happened to me. Im installing SQL2K on a virtual machine. (The host is a win2003 box running Virtual Server 2005 R2). The OS for the VM is XPSP2 and the machine is standalone (workgroup). When i run the SQL install it h...more >>

I have a table call Master and a table called Rental. They both have a status field that are named differently. What i want to happen is for the Status in the Rental table to default to whatever the status is in the Master table whenever it is imported to the Rental table. ANyone have any ...more >>

Hi, A user of a VB.Net windows application gets this error message when trying to add data. She is able to add data to other tables by executing other stored procedures except in this 1 screen. I've checked the database user/role that she is using and both have execute permission for that sto...more >>

here's what I'm trying: create procedure querytotext as select * from tablename create function querytotext() returns tables as return select * from tablename bcp 'querytotext queryout filename.txt bcp 'select querytotext()' queryout filename.txt None of them working. bcp is ca...more >>

Hi, I have problems with the CPU usage on a system with 2 dual core CPUs. If I install SQL Server 2000 and run my application all 8 virtual CPU were used at one time. If I install SQL Server 2005 and run the same application just 1 CPU is used. I checked the server options: all CPUs are acti...more >>

ISSUE: I have a database that is over 200+ GB in allocated space. sp_space used on the database shows that I have 80 GB of space unallocated because I set the database up with initial and max size of the files the same with no file growth. ACTIONS: On of my files is 60 gb that I would li...more >>

I just upgraded to SP1 on SQL2005 and I seem to hit upon a bug. I have a fairly complicated query which contains a case statement in the where clause. It seems to run fine under SQL2000 SP3 and SQL2005 RTM, but it runs miserably under SQL2005 SP1. Outside of rewriting all my queries, any sugge...more >>

I had a problem today with Sql Server Express 2005. For whatever reason, the network service account lost some permissions somewhere (probably an update; I don't know what it might be) and I could not start the sql server service. I change the service to use the local system account and it wor...more >>

Can someone explain me this? I am doing some research and testing and cannot understand the behaviour I am noticing. I have a database data file = 1.6 gig and I have the tran log for testing purposes set to 101.06MB set to auto growth by 10% unrestricted file size. I also have an alert set up ...more >>

How much space on disk does a varchar use? Is it the defined length or the actual length used? If the odd entry (1%) in a large table needs a comment of say 40 characters, would an unused varchar field only take a minimum amount of space, or should the comment be in a linked table (which of co...more >>

Hi, We have some W2K3 ent edition servers running with 12 GB of physical memory. The system also created a pagefile of 12 GB. The server is running a CRM application which uses SQL. When I look in task manager, I notice the following concerning memory usage. 12 GB physical memory is inst...more >>

Hi Sql Gurus, (this is related to the post : http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_thread/thread/cad52b42320a6b60/2fe00ae19e805da1?lnk=gst&q=xtanto&rnum=1#2fe00ae19e805da1) Our custom application run on SQL Server 2000. On random period of time (but q...more >>

Another question, how to get notified via email when the switch occurs. I read that there is an event that gets fired when the switch occurs. What is the mshanism or is there an example of how to intercept this event and shoot off an email? ...more >>

I read about Mirroring feature in sql 2005 and I am thinking of using SQL DB mirroring fo a database used by a third party tool. I have no control on the connection strings, what I would like to do is to switch client machines manually (force it) to the mirror server in case the principal se...more >>

Hallo, ich habe noch nie mit dem Profiler gearbeitet, muss aber jetzt zur Fehlersuche bei einem Kunden den Profiler ein paar Tage lang mitlaufen lassen. Ich gehe per RemoteDesktop auf den Zielrechner, starte den Profiler, aber wenn ich mich wieder auslogge, wird er wieder gestoppt, weil er...more >>

i have a database backup file which is backup from SQL server 2000. can i restore it at SQL server 2005? ...more >>

I have one db which i restore form other db server in standby mode. Now user exist on the new server but they r not mapped to the standby db. How can i assign the user to standby db ...more >>

Hello! I never worked with Profiler before but now I have to do so. I want to capture some events in a productive environment. My access to the server PC is done by RemoteDesktop and as soon as I log off the Profiler that I started is stopped again because it runs in my own user context on...more >>