I am storing data temporarily in a database... and periodically need to update that huge database, so just has to copy that temp DB to the original one. Using sql may take a few hours to finish this operation. I think you can do "export" from temp database into a file and "import" into the hu...more >>

I have two servers, using SQL server 2000. I was asked for implementing hourly Backup 3 databases in one server and restore those databases to another server. Could anyone give me the detailed steps to do that? Thanks a lot in advance! ...more >>

Suppose a database server and client are separated by a low bandwidth link such as DSL, and the client repeatedly issues a query for, say, a current product list. Suppose the product list is large, but only a handful of entries have typically changed between queries. It would be nice if onl...more >>

Hi, is there a way of exporting database structure not the data in it? Thanks. ...more >>

Hi I wanna put string in query "where" part. For example, $sql="select VEHICLE FROM database WHERE MECHANIC =BRIAN "; like above, "mechanic" column is filled with strings. Then how can I write "where" part? Above query does not work. Thanks. ...more >>

Hi All, I am used to other SQL engines, and have a few basic questions-- 1)If I wanted to conditionally drop a table, does SQL Server have a way to natively do this? Many SQL implementations will allow something like: CREATE OR REPLACE tablename AS SELECT x,y,z FROM sourcetable ; ...more >>

Hello Based on three tables (Projects, Tasks and UserCalender) I would like to work out the total amount of available resources (UserCalender table contains a entry for each user for each day, day being 7.5 hours) and total required effort (sum of Tasks.EstimateLikley) split over 12 months. ...more >>

Going a bit crazy. Have sqlserver all installed and running. I have a security problem I think- have read many other news posts that SOUND similar but e.g. My SQL Server configuration manager doesnt seem to have seccurity options let alone offer the possibility of allowing a 'mix' of SQL/ window...more >>

Hi, I need to take data from a SQL Serer 2005 database, and load into a remote 2000 database. I've already been able to script and create the database objects (MS SQL Server 2005 has a nifty option which allows you to scripting for SQL Server 2000 compliance). Now i just need to get the data...more >>

I'm having a problem getting back appropriate metadata for stored procedures from MS SQL Server 2000 and 2005. I've created a simple stored procedure that has an output param that is a cursor. When I ask for the metadata for that stored procedure using a JDBC driver I get back a datatype va...more >>

Hi Is it possible to return the results of a query so that instead of having say 10 rows its concatenated, eg My query returns 'M' 10 times, can this be returned as 'M M M M M M M M M M'? Thanks Lee ...more >>

Hi, I'm developing a java application which uses SQL Server as the database. I use Callable Statements to connect to the database. I use JRun as the app server. When running the application I want to be able to monitor locks/process info etc in the 'Current Activity' section in the 'Managemen...more >>

Hello, i don't know how to format a string with an SQL select query for my VB6 App. I have a table like this : Code - Name 1 - Jonathan 2 - Mike .... 9 - Claudia 10 - Robbie 11 - Sandy But I would get code column result's with a particular format like this : 0001 - Jonathan 0002 -...more >>

Help. I have been tasked with upgrading a 2000 instance to 2005. I have actually done this before, but it was a long time ago, and I didn't do it alone. Now, the sitation is little different, and I need to know the EXACT steps to take. Does anyone have a FAQ or link that outlines migration s...more >>

Hi I have a table called "Member" as given below.. familyID memberID firstName -------- -------- -------------------- 0 7 Stuart 0 5 Kasey 0 1 Sally 0 2 Cooper 1 9 Rosemary 2 3 Lisa 2 6 Steph...more >>

Hi I'm having problems loading a new instance of SQL 2000 Developer edition as a default instance onto my laptop. Everytime I try to do so it I get a message at the end of the installation saying the 'Server failed to initialize' and refer to the set up log. When I look at the error log it ...more >>

i really want to know, there are how types of databases? how many types of servers? how many types of inernet based languages? ...more >>

In MS Excel, the ability exists to run a "web query." This function is accessed via the data menu's import external data option. The web query wizard accepts a URL address, and then is able to import the data from that address into an excel worksheet. What I would like to do is use SSIS to i...more >>

Hi, We are running a test upgrade form sql 2000 standard edition to sql 2005 developer edition. Followed through all the steps and specified the account(SA priveleges and currently used by the 2000 version) and is the local admin on the box for the services and the setup seemed to move fine, e...more >>

"The log file for database is full. Back up the transaction log for the database to free up some log space." Now I only know this way to deal with that manually, Step1. in option , chance Recovery model from FULL to Simple. Step2: go to task to manually shrink the log file Step3: Change re...more >>

In SQL Server Configuration Manager I apparently have a server named SQL Server(SQL Express) running - however, in VS 2005 when I try to 'add connection' (right click in server explorer) I cant see it- I would like to see it so I can create a new SQL server database. Any help much appreciated-...more >>

Hello! I have a developer that is playing around with some SQL statements using VB.NET. He has a test table in a SQL 2000 database, and he has about 2000 generated INSERT statements. When the 2000 INSERT statements are run in SQL query analyzer, all 2000 rows are added to the table. When he...more >>

How can I practice the use of SQL server without changing my girlfriends laptop to XP Pro (which anyway I dont have)? Using (unfortunately) Windows XP Home not Pro, Visual Studio 2005. Trying to learn SQL server with asp, javascript, vbsrcipt and HTML- new to this. Headbutted the wall for a few...more >>

Hello all, Quick sql syntax question: I have this table: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo]. [REQUESTS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[REQUESTS] GO CREATE TABLE [dbo].[REQUESTS] ( [ROW_ID] [uniqueidentifier] NULL , ...more >>

Why is dts packages out of server 2005? In server 2k they were there but in 2005 it's gone? I tried to connect to 2k using 2005 client interface and can't seem to locate the dts packages I seem to notice. ...more >>

hi I want to increase a varchar(5000) to varchar(8000) on a table that has approximately million rows..... What is the impact on the server or any good recomendations of a action to accomplish this in the best and fastest way. thanks davep ...more >>

To start with, I'll give a simplified overview of my data. BaseRecord (4mil rows, 25k in each Region) ID | Name | Region | etc OtherData (7.5mil rows, 1 or 2 per ID) ID | Type(1/2) | Data ProblemTable (4mil rows) ID | ConcatenatedHistory The concatenated history field is a nvarchar wi...more >>

Hello I'm seeing the backup using SMO fails with big databases (>15GB). I have a 2GB database and I can see the command go thru. in Profiler but after it's about 50-70% done, I get an exception saying backup failed. There is no details on the SQLServer log. Here's the code snippet: bk.Init...more >>

Hi, I'm trying to write a java.sql.Date to a database and the minutes/ seconds etc. are not being written. I've seen and tested many examples found via searches and still have come up with nothing. Here's what I have: java.sql.Date formation - recommended constructor forms: java.sql.Date en...more >>

When I click on the properties of a 2005 sql server database and then permissions. If I select a group and then effective permission, I got an error, saying that "cannot execute as the principal server because the 'xxx \group' does not exist, this type of principal cannot be impersonated, or yo...more >>

Hi, I am starting a new job next week. Part of what I am required to do is a "system diagnostic" on a SQL Server 2000 box to determine what areas can use improvement - this would include configuration settings, backup/recovery, sql tuning, etc... and anything else I may not have mentioned her...more >>

hi, does anybody know how to enable/disable xp_cmdshell in sql server 2000. i our server this sp has been disbaled for security puropse.but i need to use it in a job.so please can any body guide me? thanks for the help. -Shark. ...more >>

I have a date/time field with a sql format of "datetime" The actual date/time data format is MM/DD/YYYY^hh:mm:ss:pm or "1/25/2007 12:00:16 AM" Both the date and time are combined on the same field with a space seperating the two. I need to run a query on this date/time field using the criteri...more >>

We have a stored procedure that we've tried with two slightly different designs. It needs to take a 30 day date range and return a result set. Design 1 takes one date as a parameter. The other date is calculated in a local variable to be 30 days before the one that was passed in. Both data ...more >>

SQL 2k, DDL below. I have a simple table with the following data: fldYear fldCode1 fldCode2 2000 ABC1 ABC12 2000 ABC1 ABC13 2001 ABC1 ABC12 2002 ABC1 ABC12 2002 ABC1 ABC13 I need to know, for every distinct combination of fldCo...more >>

declare @ContactId as integer set @ContactId = 5 select * from Person.Contact where ContactId = @ContactId OR @ContactId = -1 If you run this in SQL 2005 on the AdventureWorks database, why the logical reads is 561 Table 'Contact'. Scan count 1, logical reads 56 an...more >>