I would like to search and replace a NTEXT field in sql server 2000. Does anybody know how to accomplish this? Thank you. ...more >>

I have the following Microsoft SQL Server 2005 items installed on my XP SP2 dev machine: =B7 SQL Server Configuration Manager =B7 SQL Server Error and Usage Reporting =B7 SQL Server Surface Area Configuration None of these tools allow me to create/open/edit databases... Where do I get db sch...more >>

Hello, I have this command line for backup: BACKUP DATABASE [MyDB] TO DISK = N'C:\backup\MyDB_daily.BAK' WITH INIT , NOUNLOAD , NAME = N'MyDB_daily_backup', SKIP , STATS = 10, NOFORMAT but Id like this name of backup: "MyDB_daily_%date%.BAK" so for exmaple "MyDB_daily_2006-11-30.BA...more >>

Panicked, as usual. Who says it's great being a sole proprietor? Three tables: A_Appointment, AX_Appointment_Entity and E_Entity. AX_Appointment_Entity is an intersect/association table between A_Appointment and E_Entity. One appointment may have many attendees (Appointment_Entity). One attend...more >>

I have spent the best part of 4 days trying to connect to SQL 2005 express from an winforms app! Yes , I have checked surface config and TCP/IP blah blah ... I have trawled the net and spent countless hours on MSDN and many have tried to help. I have changed the passwords to strongly typed... ...more >>

I want to install SqlServer 2005 Express in Disk D not Disk C. What commond shoild I have to run? Please give me a favor, Thanks Any ideas appreciated ...more >>

Hello all, I've installed the SSIS component and i'm trying to import data into an existing table. I can't find an option, via the import/export wizard, to direct the import to a specific table. What happens currently, is a new table is created each time I import. Does anyone know how to d...more >>

I have a table containing data. I need to append some more data from a csv into the same table. I would have used DTS on sql server 2000 but I cannot see how to achieve the same with sql server 2005. Any ideas? EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com...more >>

I just reinstalled SQL Server, server & client. When I try to start, the server name comes up as GATEWAY_COMPUTE and the services as SQL server. When I try to start, I receive error message' The Service did not start due to a login failure'. It never even asks for a User ID or password. Does ...more >>

I've got a table where one of the fields is "bit" .. and I need to set it so that if no value is inserted with the new record, the value of that field should be "0" (zero) .. but instead, the table shows <null> instead!!! This is wreaking having with my ASP.. Entering in 0 by itself in the "De...more >>

MSDE is used by Server 2003 for intranet and monitoring. Will it interfere with the installation of SQL Server 2005? Daniel ...more >>

Hello, I'm trying to get my database setup on my isps sql2000 server and am having trouble getting the object prefixes to make sense. What I would like is for all new objects to be created with the dbo prefix, perhaps so that I don't have to explicitly use either the dbo or any userid pr...more >>

Hi Using SQL Server 2005. I have a fairly complex query that I apply paging to using the With statement like (dummy sample taken from http://davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx) WITH LogEntries AS ( SELECT ROW_NUMBER() OVER (ORDER BY Date DESC)AS Row, Date, Descript...more >>

hi, please, how to drop schema with all schema objects? thx ...more >>

I'm new to SQL 2005 and am wondering if there is anyway to export/script a 2005 database (including the data) into a file, then import that file into SQL 2000. I've tried using the script option in Object Explorer, but I don't seem to get the data into the script file with it. Thank you for ...more >>

Hi, I have a sql 2000 production back up file (.bak) around 10 gb in a NETWORK drive. But i have only 9gb local HD space. I am interested in restoring only the data (.mdf) , not the log to a local db from the network bak. I think the data will be around 2 gb or so. Is there any way i ca...more >>

Hi all, We were about to buy a copy of Windows SQL Server Workgroup edition. We noticed that the supplier sells both boxed version and MOL versions. We will later on need to buy additional CAL's, and only noticed these marked up as MOL items. As the prices were the same, is there any reason t...more >>

From my SQL Server database, I would like to add a link to a table in 4D. I don't see how to do that, and cannot find any documentation. Can anyone help?...more >>

Hi, I need to learn about SQL server. Ultimately, I would like to use it for business intelligence, to learn about my customers (e.g. how many are above 65, are male, and have x product). I also need to create management reports, and extracting info for a company scorecard would be great...more >>

For default values in sql server 2000 should I use brackets around default values? E.g. Is there any difference between GetDate() and (GetDate()) and 0 and (0). Both methods seem to work fine, but is there a correct way? Thanks ...more >>

I have a maintenance plan set-up to backup all user databases on SQL 2000 Server. I was wondering if there is any way to modify the .bak file format. Currently the bak files are (saved to disk and written to tape) with the following format (user_db_2006111160200.bak.) Is there any way to exclud...more >>

I have a smalldate field show as yyyy-mm-dd mm:ss I like it to show mm/dd/yy. What can I do? Thanks. ...more >>

I need to copy a view from one server to a local MSDE instance on my computer as a table. I've created the table but I'm not sure what the best way to copy the data returned from querying the view would be. Currently to run a query against that view on the server it is on, it takes about 30-...more >>

Hi all I saw that in sql server 2005 express - I can right click a stored procedure and run it. Is it possible in sql server 2000? How please TIA Guy ...more >>

What's the difference between a role and a schema? Both appear to be bundles of permissions owned by a user. But a schema can be owned by only one user, while a role can be assigned to multiple users. If that's the case, then when creating a new database user in SQLSMS, why do I have lists ...more >>

I got this warning: Warning: The table 'survey06' has been created but its maximum row size (96219) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes. I'm not sure what this means to me. ...more >>

What is wrong with this statement ? SELECT Caseid FROM (SELECT DISTINCT Caseid, userid FROM Atts) A ...more >>

I have a page where I set the value of a variable this is the name of the variable: attynumber Code to assign the value to the variable is VB: <% Dim str str = Request("AttyParalegals") str = Trim(str) Do While InStr(1, str, " ") str = Replace(str, " ", " ") Loop Dim numberofw...more >>

Is it possible to count the number of items from a comma delimited string ? I select * from table where id IN (parameter) the parameter is: 18,23,324,34 That is four items, is it possible to count how many items are in the string ? so that the results in the case above results would be : ...more >>

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

I have been unable to do this query, perhaps an expert can help. I dragged too much and now client needs this urgently, like if they ever don't :) .. anyways, any help is greately appreciated. I am using MS SQL 2000, I have 3 tables. Table#1: Baskets 3 basketid int 4 0 0 basketname nv...more >>

Where can I buy a book or learn more about SQL Server 2005 Express. I want to learn more about it. Thank you in advance. ...more >>

I planing to make an enterprise wide inventory database using Visual Basic.Net and I wondering if SQL Server 2005 Express can handle 30 users at a time and from different parts of the United States or do I need to buy the full version of SQL Server. Thank you in advance. ...more >>

I used to have a Microsoft SQL Server application set on my laptop that included the following tools: Books Online Client Network Utility Query Analyzer Configure SQL XML Support in IIS Enterprise Manager Import and Export Data Profiler Server Network Utility Service Manager Does any...more >>

I use ms access as a frontend and have been running a daily update from an as400. Today it failed and said I must use an updateable query. Any ideas on what could have happened? Thanks. ...more >>

I'm not even a novice on SQL, so this may be out of my league, but I need to find out how to convert SQL Tables to Flat files. I imagine I will need a converter of some sort, right? The scenario is... a subcontractor sent files to us in SQL Tables unlike the last year when they were sent in a ...more >>

I have a string 20061016 that I want to convert to a date field so it winds up like this: 10/16/2006 What's query syntax to do this? Thanks. ...more >>

Hello, From the nature of the question you will probably gather I am not a SQL admin. Recently we had an issue where the server our SQL instance resides may have been compromised. As a check I would like to determine when SQL account where created in case one was added that should not be ...more >>

I had to change my sql database to Simple recovery method because of Windows One Care runs VSS. After I changed the data base to simple my maint plans fail to run. I get this error: Event Type: Warning Event Source: SQLSERVERAGENT Event Category: Job Engine Event ID: 208 Date: 11/6/2006...more >>

I am trying to create backup scripts using SQLCMD I have a database whose name is has a hypen - data-base SQL requires the name to be provided in quotes BACKUP "data-base" TO DISK='D:\destination\file.bak' WITH INIT Now, I am not sure how to do that when I have variables that get substitut...more >>

All Certifications Like MICROSOFT,CISCO,COMPTIA,SOLARIS,ORACLE,SAP,MICOSOFT BUSINESS SOLUTIONS,EMC at your doorstep without exams..and with 100% passing guarantee...No need to go to any testing centre...we will do everything on behalf of you... We own several test centres worldwide and are able...more >>

Not sure what I'm doing wrong. Here's the sql statement and the errors I'm getting are afterwards. Thanks for your help! UPDATE Sam.TWDHPO SET Sam.TWDHPO.ConfirmedShpDate = Sam.tblDateSelected.NewDate, Sam.TWDHPO.ScheduledDate = Sam.tblDateSelected.NewDate, Sam.TWDHPO.POAcknldgmntDateT...more >>

In SQL Server 2005, is there a way of printing off the list of tables? Like there was when you right clicked in SQL 2000. Thanks Vayse ...more >>