Hi. I have a table with 338859 records. The table has a userid column of type varchar(20) (null enabled). I use the following query: select * from table1 where userid = 'X' with X being a random userid. This is a slow test computer with 512 Mb ram and Windows 2000 Advanced Server. ** ...more >>

I created a simple table in a SQL Server 2000 database under the dbo account. When I log in under a different account (developer) I cannot see this table. If I try running a query that refers to the table, I get the message in this post's subject line. I have created other tables in this ...more >>

Will you please let me know how to have a smooth and NO DOWNTIME migration from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final version does not upgrade itself from Beta 2. Thanks John ...more >>

What SQL Server 2000's issuses are solved in SQL Server 2005? What SQL Server 2000's issuses are remain in SQL Server 2005? Is there a bug fix list for SQL Server 2005? Similar to SQL Server SP1/2/3/4... Thanks....more >>

Hi, How do I bring up the standby server online in sql2k by restoring the last log backup(backed up with noinit). This log file has been restored with standby clause. can I restore again with recovery? Thanks, ...more >>

Hello, I have a vehicle database 100,000 records with Year, Make, Model, Body,Vin, SRP text fields. What I would like to do, is delete duplicates records with the lowest SRP field, example below. Looking for any possibilities with Access or MS SQL Server. 91 Ford F-150 Tr...more >>

Hi All, I want to set Date format as British (i.e. dd/MM/yyyy 30/11/2005) in my Database. What I will have to do for this. TIA ...more >>

Just a good news post, that there's at least one report here that a trial installation of SQL2005 is running one big, fat, slow SP something like 20x faster. This is a big, complex SP (if I have the name right!) and in SQL2K it seemed like some of our big SPs simply boggled the optimizer, req...more >>

hi all, I'm trying to implement mail sending, using the xp_smtp_sendmail proc. pinging my smtp server works just fine. and when sending a mail the proc returns code 0. (success) but, somehow, the massage doesn't arrive to the mail box. I'm using win 2003. as far as I know it's supposed to ...more >>

Can anyone recommend any best practices for restoring local packages? In a disaster recovery situation I will have 1 SQL Server box rather than 4 so I won't be able to restore all of my local packages by restoring MSDB. Any thoughts? ...more >>

Hi All, Can anyone tell me whether backing up the transaction logs for the master database is the equivalent of backing up the transaction logs for all the db's on that server or is it strictly backing up the transactions for the master db? Thanks in advance, -- Elecia...more >>

It will not let me do the upgrade. I receive the following message: Name: Microsoft SQL Server 2000 Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help...more >>

I have installed the SQL Server 2005. I can create a new Database. but i cant create a new cube in analysis service. how can i connect to my created Database ???? ...more >>

Hi everyone! How can I do to debug a Stored Procedure in SQL Server 2005 from SQL Server Management Studio? I looked for the Debug... option when I right-clicked the SP but it seems that in SQL Sever 2005 doesn't not exist. Thanks. Jaime Lucci ...more >>

Hi Has anyone had any SQL performance issues when Hyper Threading is enabled on BIOS? Do you have any comments regarding to HT? I know this is a bit of a grey area for Citrix - but i have not seen any comments about this for SQL Regards James ...more >>

When I try to start the SQL Server Agent I am getting this error. [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) Thsi is very frustrating and i cant put up the DB until im sure that I can have my backups working. Anyone kn...more >>

I have SQL Server 2005 Enterprise Edition; I don't see the following components: 1. Database Services, 2. Analysis Services, 3. Reporting Services, 4. Notification Services, 5. Integration Services Please help me find/ and install these components. My operating system - Windows XP - Pr...more >>

I have found that we have a old VB programme executing raw sql that is using over 95% of our procedure cache (using sysprocesses.memusage). All our other apps use stored procs. However I wanted to understand this figure better. BOL describes sysprocesses.memusage as the number of pages in ...more >>

Hi, I have a Student table and course table. Every student will enroll in 3 courses. The strucutre of the table is Student ----------- Studentid, Student Name, Course1ID, Course2ID, Course3ID I have the course table Course ------------ CourseID, CourseName Can someone ...more >>

If I try to filter the SQL Profiler data by Database name, it has no effect. Is this a known bug or am I doing something wrong? If I limit it by Database ID, it does work. In addition, if I add the Database Name to the list of columns, it is always blank. What am I missing? On the clien...more >>

Hi, Is this possible to rename the virtual server in a cluster environnement ? I use SQL2000 with win2003 server. ...more >>

Hi just wondering if anyone has any ideas what would cause an automatic backup to fail when the manual backup works fine? There seems to be plenty of disk space. Also there does not to be a log created showing any error messages when the backup fails. The autobackup was setup in Enterprise ...more >>

Hi, I have searched the web for several hours now to find a reference solution based on the available features of Sql Server 2005 to implement a data base with multi language support. I would like to create a database that is able to store multiple translations (text in different languag...more >>

Hello Everyone, I'm in the process of upgrading my SQL 2000 from SP3 to SP4. I've read Microsoft's technical versions of their Readme's, however can someone provide me with a link to a better resource when applying SP4 to their SQL 2000 server? I would like information about restore p...more >>

I've been playing with the SQL 2005 log shipping and have been running into a few problems. My system is configured on a virtual server with two instances of SQL 2005. The OS is Windows 2003. I'm shipping logs from the default instance to the named instance with the default having the prim...more >>

hello, i listen that exists many tools for register all the changes made to the tables, for audit purpouses, can somebody recommend to me what options exists... ? exists free option? ...more >>

Originally posted on Reporting Services newsgroup - Then on Setup - no answer there though, so I thought I'd try the Server group as well. I've looked through documentation and can't find an answer there, and nothing on the web that seemed to apply either. I'm hoping someone can give me a pu...more >>

Hi, I am trying to create a DTS package wherein the data from the sql server is transfered to a text file. I am using the Transform Data Task to transfer the data.In Transform Data task properties, I build the query and able to preview the data but when i click OK in the Transform Data task p...more >>

I'm having a strange problem and I was hoping someone could give me some guidance. I am accessing a Microsoft SQL 2000 server through ASP scripts on our webserver. The sql server and web server are on the same network. This code used to work, and started acting strangely after I moved it to...more >>

I am planning to implement log shipping between two servers. I understand that if I perform a full database backup of the primary database during the log shipping, this will have no effect on the log shipping. If I am log shipping every 30 minutes, so I have a log backup at 09:00 and 09:30, ...more >>

Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN redundancy. -- Thanks AnilG...more >>

Hi, I wish to get snapshots of MSSQL data nightly, the problem is that I cannot use another MSSQL server, is there any easy way to get snapshot data every night in some readable formt for Access or different SQL server such MySQL ? regards Peter ...more >>

Hi all! I have a table containing fields like: PRODUCT_ID, UPDATE_DATE, PREVIOUS_AMOUNT, AMOUNT the primary key is PRODUCT_ID, UPDATE_DATE, and the PREVIOUS_AMOUNT is simply the "AMOUNT" of the same product in previous row (order by date) Currently I use cursor to update the PREVIOUS_AMOU...more >>

We have performed production daily backup and transaction log backup every hour for a couple of years. We are using SQL Server 2000 SP4 with FULL recovery model. This afternoon at around 4:15pm, end user says that he has deleted a number of files and would like to restore from backup for h...more >>

Hi, I have set British English as my default English. The DateTime field still accepts the date as mdy. Why? Thanks Vivek ...more >>

Hi there I want to write the results of a select-sql to a textfile - the select is executed from a stored procedure. I have looked through the booksOnline, but couldn't find anything usefull. Does anyone have a sample or something that shows how to write the result of a select to a text...more >>

My SQL Server 2000 (SP2) performance counters are missing/corrupted. They seem to be in the Performance COunter drop down, as a series of 4-digit numbers. The SQL server runs on a active/passive Windows 2000 clusterconfiguration (W2K SP3). I've tried manually reloading them with lodctr and...more >>

I have an integer field set identity ON. How can I reset the identity number to 1? Thanks Anyway!...more >>

Hi Everybody, I'm new with Sql Profiler tool and I'm trying to trace a Stored Procedure to run the Index Tuning Wizard for it. The problem is that I used the SqlProfilerTuning template and I put filters like: DB name like mydb, ObjectName like GetMyItems but I still get the execution of every pro...more >>

Hi, I am someone new to SQL Server in general. I am using the Trial Version of SQL Server 2005. I want to create a stored procedure to create a table. The table name would be the only parameter of the stored procedure. I was thinking of something like this (I dont know if even the syntax ...more >>

I'm experiencing an odd installation problem with SQL server. The server machine had two versions of SQL installed, SQL Server Standard edition, and MSDE. I don't know why. Nobody admits to installing MSDE. It was a miracle installation. Anyway, the server platform is Windows Server 2003. I've...more >>

Once upon a time, some version of SQLServer was supposed to do timestamps as datetimes, so you could have a guaranteed unique token that decoded to a real date/time. I believe this was supposed to be the ANSI standard for SQL as well. Has this yet been delivered in SQL2005? (I think not, b...more >>

A couple of questions about Merge Replication (involving two 2000 servers): 1. From what I read Merge Replication requires a uniqueidentifier column and will create one if you do not already have one. Correct? 2. If #1 is true, then do you have to have primary keys for every table involve...more >>

hello, i need to reference a table in a sqlserver instance from a stored procedure in a different sqlserverinsctance... it's possible reference the table from the stored procedure? ...more >>

I was told to run the query listed below in the morning on my database and the other query at the end of the day. What detail information will be given from the delete and the select statement? Thanks, Morning: delete from sysindexes where name like '_wa_sys_%' End of Day: sele...more >>

Bonjour, mes anciens lots dts fonctionnent correctement sur l'interface. mais quand c'est une SP qui le lance j'ai le droit à une erreur. y compris dans la fenetre dos sur le serveur lui meme ! j'utilise dtsrun mais c'est peut etre plus lui qui est en cause ! avez vous une idée !! ...more >>

we have a box loaded SQL Server 2000 sp4 and IIS, user complaining that query is slow. recommend change to MSDE. Is MSDE 2000 using less resource than SQL Server 2000 SP4? and Why?...more >>

I've only briefly checked out SSIS and wanted to ask all the experts.....we need to do some secure FTP scheduled tasks, and I was wondering was this possible with the SSIS FTP task. Or does it just use traditional unsecure FTP? ...more >>

I have an SP that I can run in query analyzer and it takes about 45secs. The code copied from the SP runs in about 5 seconds in query analyzer. There are a couple datetime parameters passed to the SP. I have these as variables in the code that is copied. I will note that the stats/IO of the...more >>

I have run the SQL Server 2000 SQL Profiler trace on my database several times for several hours. I use the outputs from SQL Profiler trace in the Index Tuning Wizard it always recommends that I drop all indexes except the primary keys. I know this is incorrect. Is there a better tool ...more >>