Hello: I'm using MS SQL Server 2000 developer edition and trying to implement log shipping to the secondary server. I copied a database MDF and LDF files from primary to secondary server and all data is there, but this database still in recovery mode so I can not apply log shipping to it. My q...more >>

Greetings, Just wanted to know if there is any parameter in BCP utility that can ignore triggers, indexes and constraint defined for a table? any help will be greatly appreciated TIA ...more >>

I've gotten sort of fed up with dealing with regional date settings on the client side and am considering the following scheme - just wondering if anyone has a negative view of it or not: Instead of @StartDate datetime, @EndDate datetime Use: @StartDaysDiff int, @EndDaysDiff int ...more >>

Hello 2 all, Maybe my question can be very stupid, but I'm a little confused. When I run sp_who on my database, I see one process (accessing remotely my database from another database on another SQL server) many many times. Well, I assume that this is one process, because I cannot imagin th...more >>

HI, I'm pretty new to MS SQL, My problem is setting .... =Format$(Date(),"mm" & "/1/" & "YYYY") (Which is from my MS ACCESS database) as my default value in MS SQL. How can I do this since format() does not seem to be a function that is in MS SQL. The above function works great in...more >>

Greetings, If I use a "select into" to clone a table, all attributes are created correctly, however, if I use the same statement across a linked server, my identity column loses its IDENTITY specification. Is this a known issue or basic functionality of using "select into" with linked serve...more >>

Hello to all, I've fallow problem. I've a sp called as a job of SA each minute. This runs pretty nice, but from time to time, the job is aborted, and I don't know why. Considering my logging, which is implemented in DB, I know, in which point it is happening, but I don't know the exact erro...more >>

I have a table (table1) that has a bunch of fields.... [field1] [field2] [field3] [field4] [field5] None of these fields are unique, but if I combine them, then they are unique. I know there is a way to make multi-field primary keys, but when I try I get an that field1 is not unique, ...more >>

I would appreciate some help on a procedure that I have. Using Bulk Insert, I would like to import records from a text file. The issue I have is the file contains a header - '1AMC_TO_Axiz' and a footer '1AMC_TO_Axiz2". Using a format file, I can get the import to work by editing the file and ...more >>

Hi, I want to get the count of rows per each 20 minutes, is that possible? Is there a date function or any other function that I can use in Group by clause, which will group the data of every 20 minutes and give me the count? Thank you. Vidya ...more >>

Hi, I have a really interesting one for you guys... SQL Server 2000 sp3 on Windows Server 2003 If I run this query: declare @find varchar(50) SET @find = 'TTLD0006423203' SELECT TOP 250 ConsignmentID, c.Created FROM tblConsignment c WITH (NOLOCK) WHERE c.ConNoteNum LIKE @fi...more >>

Hello all. I'd appreciate some help with this one: First the DDL: CREATE TABLE [Document] ( [IDDocument] [uniqueidentifier] NOT NULL , [IDParentDocument] [uniqueidentifier] NULL , [IDDocumentType] [uniqueidentifier] NOT NULL , [Number] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_A...more >>

Hi,all, When I use following sql, an error occurs: insert into #tmprep EXECUTE proc_stat @start,@end There is a "select * from #tmp " in stored procedure proc_stat, and the error message is : Server: Msg 8164, Level 16, State 1, Procedure proc_stat, Line 42 An INSERT EXEC statemen...more >>

Witam! Mam problem z polaczeniem sie z baza danych po TCP/IP przez port domyslny 1433, nie mozna sie telnetowac ani nic z nim zrobic, poprostu niezyje. Port jest zamkniety i nijak nie moge go zmusic do jakiejkolwiek komunikacji nawet po localhoscie. Skaner portów wykrywa go jako zamkniety. Czy w...more >>

We're using ASPUpload as a tool to upload files to our server and save the details to SQLServer. However, I have an application where I need to return the pkID of the just saved file. I'm assuming that I could use the @@Identity command but cannot get this to function. Has anyone used this com...more >>

hi, where can I find and download trial version SQL 2000 Enterprise Edition 64-bit? I would like compare 32-bit and 64-bit version (system : I can Windows 2003 64-bit) Jacek ...more >>

Hi to all, I'm trying to use the copy database wizard to copy a database from the 2000 version to the 2005 version of sql server. I choose not to copy logins so I expect to find a database with only an administrative login o none at all. When I start the created package it throws an error sayin...more >>

Hi all, SQL Server 2000 service pack 3 running on Quad zeon windows 2003 server with 6GB of ram. A few months ago we split our databases into operational and completed data... So now instead of doing select * from tblTest, we do select * from tblTestboth where tblTestboth is a view like ...more >>

How do you set the "Timeout Period" in SQL Server 2005? ...more >>

Hello, I read several articles of newsgroup about the bulk delete, and I found one way is to: -create a temporary table with all constraints of original table -insert rows to be retained into that temp table -drop constraints on original table -drop the original table -rename the temporary ...more >>

Hello! Can somebody tell my something about performances when using mysql and php! Where i can find document about this performance? How php and mysql behave in use of multiple connections? ...more >>

Hi, I am using MS Access as the front end and it's using ODBC link to connect to the backend tables residing at SQL SERVER. I have some queries that are doing some calculation and the time taken to retrieve the data has been quite slow. The no of data in that table is around 500K re...more >>

Hi , I am running SQL server 2000 sp3a and i have set up my database to be in "Full Recovery" mode. I am not able to understand if i have set anything wrong here : 1. Full database Backup - every weekend 2. Differential Backup - twice a day 3. Txn log backup - 4 times a day (4hrs apart) ...more >>

I am working on tuning the procedure cache hit ratio for my server. We have added 4 Gb of memory to the server, which has helped. In addition, I have run the DBCC FREEPROCACHE, which helped for a couple of days to get the hit ratio up to about 84% (from 68%). When I use the performance monito...more >>

I am working on queries for a SQL database. I have much experience with Access and am trying to ween myself off of it. The query I am working on now is supposed to return a set of data like the following: LatestVersion(Ver)/VersionUpdate(Update)/Location(SheetNumber) A/aa1/3 This works fin...more >>

Hi, Is there a reason why we have to pay more for licensing for a different kind of processor? Why are we not charged for the Hyperthreading on some processors also. If Oracle is really conserned about the low end business market (small and medium), then they should drop their attitude on...more >>

Hello, Here is a brief summary: Table 1 = All Accounts - with fields such as Customer ID and Account # Table 2 = Deposit Balance Table - with fields such as Account #, Balance Table 3 = Loan Balance Table - with fields such as Account #, Balance All accounts are either deposit acco...more >>

I have a problem with Enterprise Manager - when I refresh list of tables or databases it hangs (is not responding) for long time - about 10-30 minutes. What is more important during my refreshement users are unable to work normally - it hangs entire server. Some other details: 1. I am only d...more >>

Hello All. We have tested following SQL script from query analyzer: -- Script begin DECLARE @I int; SET @I = 1; WHILE @I < 10000000 BEGIN SET @I = @I + 1; END -- Script end The script was tested on the folowing PCs with following results: PC 1: Pentium 4: CPU: 1.6 Mhz RAM: 256 Mb ...more >>

I'm trying to return an integer from the following table that returns the number of unique cities: tblEmployees Name City John Boston Frank New York Jim Omaha Betty New York The answer should be 3. DECLARE @EmployeeCities int SELECT @EmployeeCities = SE...more >>

What's the syntax for combining INTO and UNION clauses? What I want to do is: SELECT blah INTO newtable FROM oldtable1 WHERE <conditions> UNION SELECT blah INTO newtable FROM oldtable2 WHERE <conditions> DTS doesn't seem to like my syntax. Where should the INTO(s) really go? Than...more >>

I have two databases with multiple tables. Same tables same fileds. Both databases contain records, but they should not match each other. (I will run a report for matches before this and delete any data that is not current to ensure this is the case) How do I go about moving data from one ...more >>

Hi I am having a real issue with CPU usage by SQL Server, and it is not related to a poor query. I have a clients database that I am currently investigating some issues with. After I perform a standard task using the application, and the results have been returned to the application the cpu...more >>

Hi, I'm a relative db newbie, and total SQL server newbie and I garbled up the following query ( :xxx are parameters that are filled in by the app) SELECT PERSON.*, CASE ISNULL(cap.captiveid, 0) WHEN 0 THEN cast(0 AS bit) ELSE cast(1 AS bit) EN...more >>