I have SQL Server Manager 8.00.2039 installed because I have one program (app) installed that requires it be installed. For the first little while when I had SQL server installed it would only show up in the taskmanager tray, now MOST of the time, it shows up as a popup on my desktop and al...more >>

Hello! I have an big table with 50Gb data, written som functions that cleanup data and want to do something like this insert into newtable select id, func1(col1), func2(col2) from oldtable; I'm also plan to make newtable partioned (before insert). But how could i get the insert as fast ...more >>

Hello there... I had an intrusion into my DB and I'd like to analize the log looking for the moment and the IP the modification was. Does anyone know about free software for this? Thank you. ...more >>

Hi; My company just installed MS SQLServer 2005 ( see below the dotted line ). When a user logs into management studio all of the databases on the server are displayed in the right hand column. What can we do to have only the databases the user has rights to, display? Thanks much in a...more >>

Hi, I'm trying to do retrieve some data from a table where the content is in Greek, however, the query is not working. It's a very simple statement, but I'm missing something. Here is the table... if exists (select * from dbo.sysobjects where id =3D object_id(N'[dbo]. [REPORT_LOCALE]') ...more >>

I had thought that I had posted this yesterday but since I cannot find it here we go again. I have searched the archives but either the code I want is not posted or I missed it. I have a user create role in a database that I need to reproduce in another version of the database. Does anyone...more >>

Hi All I am updating a local table based on inner join between local table and remote table. Update LocalTable SET Field1 = B.Field1 FROM LinkedServer.dbname.dbo.RemoteTable B INNER JOIN LocalTable A ON B.Field2 = A.Field2 AND B.Field3 = A.Field3 This query takes 18 minutes to r...more >>

I would like to remove an index from my database, but I need to verify that it is not being accessed before I do that. I tried running Profiler, but it doesn't seem to be giving me the information I need. I put in a filter for ObjectName, but it seems to be ignoring it - i get several entri...more >>

Hi, I have a funny situation. Within: MSSQL 2000 SP3, everything below described is running on same PC. there is a program running, which sends information to two other programs. This information is a timestamp of the program in datetime format, which has it's own clock. The clock is inc...more >>

I am looking to populate a Schedule table with information from two other tables. I am able to populate it row by row, but I have created tables that should provide all necessary information for me to be able to automatically populate a "generic" schedule for a few weeks or more at a time. ...more >>

Hi, I'm designing a new database and I have a doubt in which surely you can help me. I'm storing in this database historical data of some measurements and the system in constantly growing, new measurements are added every day. So, I have to set some extra columns in advance, so space is avai...more >>

Hey guys - I need your help. We are using SQL Server 2000- do you think, we should upgrade to some later release of Microsoft SQL Servier or Migrate to Oracle, IBM or Sybase. I am also wondering, what do you think of Open Source MySQL and PostgreSQL. Have anyone of you using these databases. ...more >>

Hi, When I debug our sp by using T-SQL Debugger, I got following error. Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1 [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'. and when I grant ...more >>

I'm new to SQL Server, so if I'm doing anything stupid don't be mean :) I have a procedure that I use to return data based on optional parameters. It works fine, except when the underlying data contains a null on one if the fields being searched. My system uses a default wildcard for all ...more >>

How can I change a character in a string of text. I have a bunch number that have a lower case l in them and I need to make them an uppercase L. Example; 99l5555 needs to be 99L5555. ...more >>

hi, Does MS2005 JDBC Driver 1.1 support integrated security on Solaris and if so how? Thanks, MarcM ...more >>

Hello, I'm trying to create a simple back up in the SQL Maintenance Plan that will make a single back up copy of all database every night at 10 pm. I'd like the previous nights file to be overwritten, so there will be only a single back up file for each database (tape back up runs every night...more >>

Using SQL Server 2000 I need to extract all the grants made to a user created role so that I can recreate the role in another version of a database and there are more grants than I want to do by hand. Does anyone have SQL or T-SQL to perform this task that they would be willing to share? I t...more >>

HI, Can anyone tell me abt the following error while i was running my ASP.net project and codes were in vb.net? Line 1: Incorrect syntax near 'Number'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more informati...more >>

I am looking to populate a Schedule table with information from two other tables. I am able to populate it row by row, but I have created tables that should provide all necessary information for me to be able to automatically populate a "generic" schedule for a few weeks or more at a time. ...more >>

Hi! I have a stored procedure that takes 22 minutes to run in one environment, that only takes 1 sec or so to run in another environment. Here is the exact situation: Database 1 on Server 1 vs. Database 2 on Server 2 - the data is exactly the same, and the tables and index structures are ex...more >>

Hello everyone, I face currently a problem where I could need some input for searching the source of the Problem System: SQL Server 9.0 I fill from Database A with triggers Database B, everything works fine. On Database B there is a Stored Procedures that checks the records and add addi...more >>

I am attempting to compile a list of questions that will enable me assess 'at risk' stored procedures that need to be remediated in order to minimize unplanned downtime and enhance database performance. Is there a subset of criteria (parameters) from the MS SQL Server Best Practices Analyzer tha...more >>

We are running on SQL 2000 on Windows 2003. We have active-passive clustering set up. We have 16 GB of RAM on each box. This past weekend, we failed over. I noticed that the Total Server Memory went from about 15.5 GB to 8 GB. I have been trying to figure out why this has occurred. Any hel...more >>

Hey guys - I need your help. We are using SQL Server 2000- which version do you think we should upgrade to. Also, wondering if you tried any Open Source data base and any thoughts on those. Thanks guys for your help - Mark Smith ...more >>

Hello, I've a problem where some data gets updated but I don't know which process (SP) is responsible for it (it's an old installation which I've taken over). Is it somehow possible to know which process/user/SP performs an update on a special table/column? I was thinking about to impleme...more >>

guys, I have a project need to move more than 100,000 records from one database table to another database table every week. Currently, users input date range from web UI, my store procedure will take those date ranges to INSERT records to a table in another database, then delete the records, ...more >>

1. In this topic http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/b4a07b516f4a2fcd/cb21516252b65e7c?lnk=gst&q=SET+TRANSACTION+ISOLATION+LEVEL+READ+UNCOMMITTED&rnum=10#cb21516252b65e7c, someone wrote: "I've implemented SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED...more >>

Hi, I have a table that I insert a member's country into every time someone signs up. What I'd like to do is pull information from the DB such that I can see each country and the number of users from each. For example: Argentina 10 Brazil 5 Canada 3 I'm having trouble writi...more >>

SQL Server 2000 SP4. Running the script below prints 'Unexpected': ----------------------------- DECLARE @String AS varchar(1) SELECT @String = 'z' IF @String LIKE '[' + CHAR(32) + '-' + CHAR(255) + ']' PRINT 'Expected' ELSE PRINT 'Unexpected' ----------------------------- I...more >>