Hi. I had an operating system reload without detaching my SQL Databases. Now it seems I can't reattach it. This is probably for security, right. Anyway past it? Thanks....more >>

Hi, This code gives me error: CREATE FUNCTION [dbo].[InsertUserNotification] ( @NotificationID int ,@UserID varchar(200) ,@TableName varchar(30) ,@ColumnName varchar(30) ,@RecordID bigint ,@RecordNo varchar(100) ,@RecordDescription varchar(250) ,@CreatedBy int ) RETURNS bit ...more >>

Dear all, I'm trying to restore a database saved last week in a .bak file through the GUI of Management Studio but i have the following message error : "the database is in use". So i restarted the service engine SQL and changed the option to put Single User but i have still the same erro...more >>

I install SQL Server 2005 trial edition, and there is no Management Studio? I know i can download the one that comes with the express edition, but that one do not have all features... Tanks ...more >>

I would like to insert records into a non MS-SQL database that I can connect to with an ODBC data source. This is possible? If so, can you give me an example of how to connect? Thanks, Mike ...more >>

I have add/edit/delete triggers on a SQL Server 2005 table. Before updating that table, I'd like to be able to set a variable that the trigger can read and that only has a lifetime of that connection or transaction. I cannot include the variable in the update stored procedure. I tried cre...more >>

I have a simple table with trigger, for example: CREATE TABLE T(V VARCHAR(100) NULL) GO CREATE TRIGGER TR ON T FOR INSERT AS ROLLBACK GO INSERT T(V)VALUES('X') On MSSQL7 or MSSQL2000 INSERT runs without any messages. On MSSQL2005 INSERT states: Server: Msg 3609, Level 16, State 1...more >>

I am upgrading SQL servers to SP4, are there any issues to look for? Thanks, ...more >>

How do I import tables from an Access database to a SQL Express database? reidarT ...more >>

I have a web site on a clustered server. One server is hosting the website. Occasionally we get the following error message: Login failed for user 'sa'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more inform...more >>

I have a table with one text type column. I am trying to append this coulmn with whatever it has with another string. This field may have more than 8000 characters already here is What I am trying to do. Update X Set textTypeColumn = textTypeColumn + ' XXXXXXXXXXXXXXXXXXXXXXX' WHERE id = id...more >>

I want to be able to track when somebody tried to log in with an invalid userid or password. How do I do this? TIA - Jeff. ...more >>

All, I've identified a query that is causing deadlocks in our database. The SELECT portion of this query seems to be causing lock escalation - causing the whole RECORDS table to lock - and causing other processes to deadlock. I'd like to somehow rewrite this query to decrease the lock escala...more >>

Hi, In the Subject, by general users, I meant those users who did regular database operations, like insert, update, delete, etc. rather than the users who have special privileges to do database maintenance operations, like backup. We need to clean up those databases that haven't been acces...more >>

I'm working with a process that is initially invoked from VB, but runs through a set of stored procedures. The first four levels of the calls are simply gathering data that the other levels below will need and aggregating some of it. This data is used to determine if further processing is need...more >>

Hello, What is the best way to copy a SQL Server 7.0 database to SQL server 2005. Currently we backup the 7.0 database, restore it to 2000, backup the database on 2000, restore it to 2005. Is there a better way to do it? And can it be automated? ...A little background.. Our production ...more >>

Is there a way to setup a job in sql server 2005 to notify me if a database is getting close to reaching it's restricted growth limit? For example if a database is limited to 140 mb... can I setup something in sql server to noitfy me if the database gets within 90% of it's restricted growth li...more >>

Hello, I can see in footnote for SQL 2005 standard edition that mirroring is = only available for " 2 Local Machine, same SQL Server Edition, relational data only. =20 " What does it mean "Local Machine"?...more >>

All, I'm getting the following error when running a BULK INSERT via T-SQL: Server: Msg 4866, Level 17, State 66, Line 1 Bulk Insert fails. Column is too long in the data file for row 1, column 3. Make sure the field terminator and row terminator are specified correctly. Server: Msg 7399, L...more >>

Hi, I'm having problem inserting and storing data from asp.net web form to SQL database. I use the following parameters for the SqlCommand object to do the insert: cmdTest.Parameters.Add(New SqlParameter("@FirstN", SqlDbType.NVarChar, 25)) cmdTest.Parameters.Add(New SqlPara...more >>

Hello, I have a table that has 3 date fields. I need to compare the 3 against each other and get the max date. What would be the best way to do this, function, case statement in a stored procedure? If there is any code available, I would greatly appreciate it. -- Thanks in advance, sc...more >>

I have a strange situation. A SPID is blocking 3 other SPIDs. The blocking SPID's lastwaittype is PAGELATCH_UP and the waittype is 0x0413 (Update buffer page latch). The waitresource is 2:1:444 indicating something in tempdb. The blocked SPIDs all have the exact same lastwaittype, waittype and...more >>

Hello, I have installed the SQL Server Desktop Engine on a server. I know this doesn't have a GUI, but I am wondering if there is a way to interface with this. I have seen Microsoft KB articles that require you to be able to change things with the SQL server, however, these always refer to MS...more >>

I have just installed SQL server 2005 standard edition - how do I create a basic server and user accounts in order to then install Project Server? ...more >>

When is SQL 2000 going ot of suppprt?...more >>

Hi, I have a table that contains approx 2000 rows where a timestamp is the primary key. I want to search between two dates and return the results order by the timestamp in descending order. The problem arises as I only want to return a maximum of 50 results starting with the oldest. E.g. if I...more >>

Gurus, Occasionally I get the error of "WARNING: Failed to reserve contiguous memory of Size= 65536." What is the unit for this size, is it bytes or KB? Additionally, I have set up 511 MB for MemToLeave area by adding -g384 for Sql2k SP3a on AWE enabled system. I have total of 16 GB of RA...more >>

I've a problem with permissions. There are a few Production SQL servers. One of the guys is a SYSADMIN on server A only. And 2 of the other users(including me) on that box r sysadmins for all the boxes. If this user creates a JOB on Server A to do some stuff on Server B and makes me the owner...more >>

Hi Guys, I am facing a problem with sql server 2000 sp3 backup to network.This backuP is as part of scheduled backup to another server in the same network and was working fine for the last 3 yrs But Recently the backUP is failing with following errors BackupMedium::ReportIoError: write fai...more >>

Hi, I made a release on system at 12pm 22/02 and overwrote a table by mistake. I have a back from from the night before (12 at night) but from the time I did a backup and and the time I did the release some records would be lost. I want to recover the data lost. Can I examine the tr...more >>

I am creating 3 views from the linked server and then I have a question at the bottom returning results. If I exclude the ORDER BY from my question the query will take about 40 seconds, with the ORDER BY it takes about an hour to finish. Is this normal ?? code below ------------ creat...more >>

Hello, I am currently working on an application which calls some CLR stored procedures in SQL Server 2005. The first time one of the CLR stored procedures (it doesn't matter which one) is called it takes a lot longer to execute. After the first CLR stored procedure has been executed the CLR...more >>

Hi, When I add WHERE CLAUSE IN UPDATE query the OUTPUT Clause doesn't work. This code works : DECLARE @OldProposal TABLE (ProposalDesc varchar(200)) UPDATE tbl_Proposal SET ProposalDesc = 'yu' OUTPUT Deleted.ProposalDesc INTO @OldProposal SELECT * FROM @OldProposal and this cod...more >>

2006-02-24 02:54:07 - ! [380] unable to start thread JobManager ...... 2006-02-24 02:54:20 - ! [165] Erreur ODBC : 0, =C9chec SQLAllocHandle du pilote sur SQL_HANDLE_DBC [SQLSTATE IM005] 2006-02-24 02:54:20 - ! [382] La connexion au serveur =AB (local) =BB a =E9chou=E9 (SubSystemStepHistoryLogge...more >>

Hi, On MS SQL Server 2000 SP3, what are my recovery options when only the database transaction log becomes unavailable and when there are active transactions in the database? Sp_detach_db/sp_attach_db/sp_attach_single_file_db doesn't work in this scenario, I have tried that. Are there an...more >>

Hi Does the profiler catch every activity on the server. I mean what about the various username & password screens , dont you think then its a threat to security . & I wanted to knw how to get the last 10 SQL Statments issued by the users client to the SQL Server. dbcc inputbuffer (spid)...more >>

A client of mine recently discovered that certain records were deleted on their SQL 2000 server. Is there a utility that I can use to look back at the transactions to find out what happened to those records (i.e. who/what deleted them and/or what time)? ...more >>

Hi everyone, I was hoping someone could help me. I am having problems with my transaction log not shrinking after a log backup has taken place. The log backups are usually of size 400 Mb at 7:00am and generate further 6 MB (approx.) log backups each half hour. The log file is usually of size 3...more >>

Hi All , This link is from a previous posting http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm and i followed the instructions . I am looking for logins & logouts and i have successfully created the trace based on the scripts. however, the trc file is always 0 kb despite me l...more >>

Is there any way to stop SQL Server 2000 from logging? It is absolutely not necessary in my app. Is SQL Server 2005 any different? Thanks very much for your time, Marc Miller "Don't look back. Something might be gaining on you" - Satchel Paige ...more >>

Hi! I am having a problem concerning collations. I have an SQL Server 2000 with Latin1_General_CI_AS which contains the company data.Some of the fields are Greek and although I cannot view them correctly in the Query Analyzer , the tool we are using (powerbuilder) displays them OK. now t...more >>

Dear all, I've got this error message on creating the linked server to the SQL Server 2000 (in Windows 2003 Server), "Error 18452: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection." The client side is MSDE 2000 (in WinXP Pro). But I can successfully c...more >>

In my MSSQL server 2000 sp4, in performanece monito, buffer memory, page life expectancy is equal to 0.0000 (average for 10 sec, auto update). I think sth is wrong configured, but what? Marek ...more >>

I've made a demo showing the use of an Event Notification. It has worked a 100 times before but all of a sudden it doesn't !!?? Here's the code and everything else is in place. I've just installed the server and it's a Developåer Edition and I'm using the good old Northwind Database. It has th...more >>

how to change database collation? ...more >>

While attempting to use SQL Server Manager 2005 to restore Test1 to Test1Copy1 at least 9 times out of 10 I get the following error: // Restore Test1 to Test1Copy1 System.Data.SqlClient.SqlError: The file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test1.mdf' cannot be overwrit...more >>

Hello, How is load balancing working in SQL Server 2000. We want to have two different servers as a back end for our web based eCommerce application. Is this possible? While there be any modification requirement in the application? ...more >>

We have a SQL service that consistently seems to take about 10-12 minutes to start up. After it finally started, everything is hunky dory. I was able to review the SQL Server logs in the Enterprise Manager. The SQL startup hangs on "attempting to initialize distributed transaction coordinator." ...more >>

With SQL 2005 Standard: I have records in a table that show how long it takes to complete a task... ID_KEY DATETIME (nearest minute) DURATION When a task is started, a record is added with a "null" duration, and when the task is finished, the duration is updated to represent the...more >>

Hi Why the option Use Windows NT fibers isn`t work in Windows 2003. What can I do for use this option and use more priority with SQL server? Using SQL 2000 in Windows 2000 is better. Why? Please help me. Ideas Mr I have SQL Server 2000 in Windows 2003 using Threads with .NET ...more >>