Running SQLServer2000 SP3. I have a database (DB1). I need to make a copy of that database (DB1_Test). The new database (db1_Test) should have all of the structures, permissions, etc. I don't want any of the data. Can someone help me? -- Tom...more >>

I'm running SQLServer 2000 Standard. I have a database that is set for Recovery Mode = Simple. The dboption "trunc. log on ckpt." is set to TRUE. I have also issued the truncate log command "BACKUP LOG DB_Name WITH TRUNCATE_ONLY". I have penty of available disk space. I still get the fo...more >>

Hello, If I have this table: IdNo int Version int data ... IdNo and Version is the primary key. How would I write an SQL query to get the latest version of a all IdNo? // Anders -- English is not my first, or second, language so anything strange, or insulting, is due to the tra...more >>

I've just split my db and am using Access as my front end. Are there any advantages / additional functionalities of having SQL Server as my back end that I can take advantage of? ...more >>

SMS Query complains about the backslash in the following statement. ALTER SCHEMA dbo TRANSFER OWRD\julainih.AuthorList The old trick of doubling the backslash ALTER SCHEMA dbo TRANSFER OWRD\\julainih.AuthorList doesn't work either. What do I need to change to let this statemen...more >>

Hi, I've been trying to find desupport dates for SQL server 2000, but having difficulty finding anything. Can someone provide this information to me. Also, information about upgrading to 2005 would be helpful too. Thanks, Mike...more >>

I have the following "Where" clause WHERE (dbo.UserLogin.Enable = 1) AND (dbo.Users.Archivedcont = 0) and convert(char(8), loginstartime, 108) < convert(char(8), getdate(), 108) and convert(char(8), getdate(), 108) < convert(char(8), loginendtime, 108) But I only want the second line of the...more >>

I have the following query: Select convert(char(8), loginstartime, 108) as startime, convert(char(8), loginendtime, 108) as endtime from userlogin It returns two values: startime = 08:00:00 endtime = 18:30:00 Right now it is 10:40 am If I add a where clause I get no results when in...more >>

hi, I need to synchronise local and remote database but only the stored procedures... Any ideas on how to collect all local ones and then create these on remote db? ...more >>

So, I have a View built where the criteria on a date field is as follows: > { fn NOW() } ..... but what its showing, is everthing from TOMORROW forward... I still need for it to display TODAY's information as well. What do I set in criteria to show this? > "yesterday" somehow??? ...more >>

I thought that when you installed SQL Server 2000 the installation automatically recognized an instance of MSDE and offered to upgrade you. Well, after having installed SQL Server 2000 it looks like my database still thinks that it's MSDE. At least I have both SQL Server 2000 and MSDE runnin...more >>

Hi, I am using ASP/VB and MS SQL 2000 DB. I have a date field that just holds a 'time', say 8:00 am Then I have an ASP page where the user enters the time to compare, they will search for results that have 'time' field between say 7 am 10, in this case the record with 8:00 am should be di...more >>

Is it fair to assume that the maxium number of Index on any given table in SQL Server 2005 is 249 and 1 index can be clusted for a maxium of 250? Is this count also the maxium number of relationships that can stem from that table. I am pretty sure it is, but I would like other experts to comme...more >>

how can i insert an access recordset to an sqlserver table? thanks ...more >>

how can I update only top 20 rows in a table? The table consists of PostlistID int, UserID int, Send_Begin datetime, Send_End datetime and what I'm doing is to sequentally -grab next 20 rows of recipients and set Send_Begin to GetDate() -send these users email -update Send_End to ...more >>

Hi, we need to purchase SQL Server 2005 for a new hr system that is being installed. We are thinking of getting the Microsoft SQL Server Standard Edition 2005. It says that it comes with 1 server license and 5 user cal licenses. Forgive me for this really dumb question but what does the 5 u...more >>

Hi, I am fairly new to T-SQL although I would not classify myself as a complete beginner. Last week I came across a strange business requirement for an application, and I am still trying to figure out how to address it in T-SQL. I need to pull a list of each customer's last order for a s...more >>

When I try to install SQL Server 2005 I get a message that says: SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add and Remove Programs to remove these components. I haven't installed any beta softwar...more >>

Hi, I have a stored proc that returns an entryid. When i tried to execute the proc and assign to a variable in the sql analyzer, i am not getting the correct output in the variable For eg: In the make_user_signup stored proc, ...... ....... Select @entry_id as EntryID GO When i d...more >>

I have a database where I need to change all period to post information back 1 year. There are approx 400 tables and most of them have a perpost field where the Period to post information is stored. I need to take this information back 12 months for all perpost fields. eg Perpost in APDOC ...more >>