Hello, I am attempting to create a SQL Statement that only returns certain rows to data and am having a very difficult time getting it to work. This is what I am trying to do: I have a table full of data: ID CustomerID, CustomerFirst, CustomerLast, CustomerBalance, TransDate 1 ...more >>

Hi, Could someone suggest a small free utility to create simulated load? I have some small SQL scripts that I would like to run against my sql server but from 200-300 (simulated) users. Thank you. ...more >>

I am trying to devise the best way to perform the following: Import/export word documents into and out of a table in SQL 2005 for a VB program to access. The user of the program would be able to choose what doc they want to import into the table thus the location of the file and name of th...more >>

Is it possible to create Synonym of Oracle Procedures & Objects in SQL Server 2005 and if so will they work through a DBLink. Regards, Trevor Benedict R ...more >>

I have a SQL Server running and I need to know if SP4 is installed on it. How can I tell? Thanks, Chris ...more >>

I nee to execute a proc on few servers and store the results on a central database in a table. How can I do this without writing the DTS packages? I tried the Sybase way ( Server...sp_myproc) and it did not work. I added the linked server before trying this. Any pointers?? Thanks ...more >>

Folks, Can anyone help me with getting results of a query that I'm trying to execute on a linked server into a local table? I'm trying to avoid the DTS package as I will have to create the DTS package on every single linked server. I have quite a few servers that I want to execute a proc on...more >>

We are trying to install Service Pack 1, after clicking on exe, at about half way, it just gave us "Unexpected Error Occur" pop windows saying "The following unexpected error occur", but did not give us any detail error. Please help. Thanks ...more >>

OWC11 Error From Setup log Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Failed Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0006_L0082986_OWC11_1.log Error Number : 1603 -------...more >>

I'm in the process of migrating our production databases from our current SQL server 7 SP3 to SQL 2005 enterprise edition. We are purchasing a new server and installing a fresh copy of SQL 2005 Enterprise edition 64 bit. All the database objects will be created from scratch on the new instance...more >>

We have ACCESS applications that use MSSQL for the DB. They use a specific userid and password to connect. We are changing one to use Windows Integrated security. I think we have the users and permissions set up correctly. But when we connect using the Integrated security, the applicatio...more >>

Hi, We have created an ASPState database following the instructions in 311209 in KB. One part of this is to run a job, ASPState_Job_DeleteExpiredSessions, every minute to clean up any expired sessions from this database. Recently we had MOM say that this job was causing blocking problems o...more >>

I've recently upgraded the SQL server from 7 to 2000 SP3. The database maintenance plans were set to remove backup and log files older than 2 days, but does not seem to be working any more. I removed the plan and entered a new one last week and still the files are building and are not being re...more >>

I have a SQL database that stores image files (pdf, doc, tif etc). Is it possible to write a query that shows the size of the file being stored ? Any help would be great. Thanks Si...more >>

I asked the question last week about if there would ever be any benefit to SQL authentication over WINNT (if I had the option of using either one) and the consensus seemed to be “no”. Thanks to those that replied, but now I have another question. I currently have 2 environments. Our “leg...more >>

I am using sql authentication, and have a user who owns a database, but is not sysadmin. The user needs to debug T-SQL/stored procedures under that user account. How do I do this? ...more >>

Hi, Lately, I have been getting this problem with a client. The query returns around 6 thousand records, there is one user only and it's a select statement with a temporary table in the join. The server has a sp4 installed. It's a 2003 server. CREATE TABLE #Temp (Temp_Id INT, ...more >>

After a forced Microsoft update this weekend all of our servers went down. Now I can't start my SQLServerAgent. if i try from the Servcies.msc screen I get an error: Error 14001: this Application has failed to start because the application configuration is incorrect. Reinstalling the appli...more >>

I have a large errorlog file that seems to always be in use - can I delete it or create a new one ? ...more >>

I have some code that implements some business logic that sits on top of an SQL Server Express 2005 DB. The database is fine, but I have found a potential issue with the updates that affects my code, and also the functionality of the .Net Dataset, that I am looking for a way around. My c...more >>

I was able to create database manintenance plans for log shipping in my SQL Server 2000 databases and everything worked fine. After a week, I created new database maintenance plans for log shipping on the same instance for other databases and I can't seem to make them work. I used the same ...more >>

Hi to all, I would like some help with a query, taking in count this two tables. Table people: ID Name -- ------- 1 P1 2 P2 3 P3 Table Contract Number Quantity PeopleID --------- ---------- ---------- 000000 500 1 000000 300 2 111111 1000 1 545454 100 3 The e...more >>

Is it possible to retrieve the password for sa? Thanks...more >>

Hi, Could somebody decipher this error log, generated by SQL server... Many thanks! Memory MemoryLoad = 93% Total Physical = 2047 MB Available Physical = 128 MB Total Page File = 3949 MB Available Page File = 2034 MB ...more >>

Hai forum, When i executed the the the following query : exec xp_sendmail 'vijay@bluechipsw.com','Hai vijay' it gave the following error message:- xp_sendmail: failed with mail error 0x8004011d then i executed exec xp_stopmail --Stopped mail session afterwards i executed e...more >>

I have developed an application in vs.net and have an sql express version on one of my computers (Actually both computers). How do I connect to this database from the other machine (workgroup, not dedicated server) When I try to connect through the Add Connection I get the message 'An error h...more >>

Hi, I have a SQL Server Enterprise Edition running on Windows Advanced Server. The windows server has 8Gb memory. What steps or settings I need to do to use the memory efficiently such as /3GB or AWE ? Awaiting your reply ! Regards, Johnny ...more >>

I am trying to implement auditing the cheapest way possible. I know SQL Server users get logged but how about NT users? -- MCP MCDBA MCAD MCSD MCT MCTS:SQL Server 2005 "Helping people grow and develop their full potential as God has plan for them"...more >>

I am having trouble moving BLOBs (text fields). I have a 200Gb database in a single data file and want to split it into 4 even sized files (I have my reasons). To achieve this I plan on adding 3 data files to the Primary filegroup. From there I will issue a DBCC dbreindex on all my tables, ...more >>

I noticed while doing some testing with Profiler, that when I execute a stored procedure in SQL 2005 there seems to always be a SP:CacheMiss. Here's the sample I created for testing: CREATE PROCEDURE dbo.Test AS SELECT 'Test'; GO I then ran SQL Profiler and executed the following from S...more >>

SQL Server 2000 SP4 running on Windows Server 2003 with two RAID 5 disk groups, A and B. I've done some monitoring using fn_virtualfilestats() and determined that of the five databases on my SQL Server, the "Fred" database's data file is getting a great majority of the reads and writes of all ...more >>

Hi, How can we select the columns count of a table? ...more >>

SQL2K5 SP1 I was able to sucessfully create a Master Key, create a Certificate, create a Symmetric Key and assign it to the Certificate, insert encrypted data, and then decrypt/ read that data. Pretty cool stuff. But Im reading up on the topic and Im under the impression that I should also ha...more >>

This questions pertains to the administration aspect. I have a table with 7 million records. We have defined about 5 indexes according to our reporting needs.The queries are performing satisfactorily.But offlate,we have observed that our insert queries are timing out. we are trying to i...more >>

I'm running a SQL Server 2000 on a Windows 2003 Server. Setup of SQL Server seems to be normal but the server use only 4 Go on the 12 Go physical of the server, even if I run several huge procedure on the same time (with high number of request and huge request). What is the best configuration ...more >>

Hi, I'm trying to figure out the amount of free space in the datafiles but since sys.dm_db_file_space_usage works only for temp, I dont know which table to join on sys.database_files or sys.master_files. Can anyone help me please? ...more >>

Hi friends, I have a question. Here's a simple table: CREATE TABLE test ( c int NOT NULL , cc varchar(77) NULL , c2 int NOT NULL , c3 int NOT NULL ) CREATE CLUSTERED INDEX idx_ ON dbo.test(c, c2, c3) Lets run 2 queries on it. First: declare @minint int, @maxint int SELECT @m...more >>

I have two int fields of a table: Count1 and Count2 I select with the sql: Select Count1+Count2 as CountSum form myTable When one filed have a value and the other with null, the CountSum will be null. I wnat to treate the null value as 0 int, So I want to 2+ null=2 How can I do? ...more >>

can running old statistics on a table which now has changed the amount of columns as well as the removal of one foregin key cause some stored procedures to not even work correctly? I know that is a long shot but my stats are in fact out of date for this table I am having trouble with. Thank...more >>

Im trying out Profiler in 2005 for my first time, but don't see a way to exclude system IDs as was possible in 2000 on the Filters tab. Is this possible? TIA, ChrisR ...more >>

I've got 2 SQL 2000 servers within my company, and I've recently changed some transaction replication objects on a SQL 2000 installation, but I now getting: Error Code: 7137 MessageUPDATETEXT is not allowed because the column is being processed by a concurrent snapshot and is being replicate...more >>

i am getting can not insert duplicate key row in objec how to solve with help of profiler i mean which recopred or row is the main problem who makes duplicates not allowing updates to come in db -- m.abdu...more >>

I access my SBS2003 only by Terminal Services. The SQL Server Enterprise Manager will not load, so I am unable to access my databases/tables through the MMC. When I log on to SBS2003 Server (as administrator) I get 7 "Microsoft Management Console encountered a problem and needed to close."...more >>

Which ones a better conference to attend ? ...more >>

What would be the difference between these 2 job titles ? ...more >>

Today we were trying to backup our W2K SBS prior to migrating the applications and data to a new W2K3 SBS. Unfortunately, the W2K Server gave us the "blue screen of death" during the backup. I have archives of the W2K Server that are 24 hour old and these are complete. We have examined the ...more >>

Dear All Someone removed some records in my table However, I haven't backup the database. Could I find out the deleted records from the _log.ldf file? Thanks ...more >>

When I try to save this stored procedure I get the errror: Must declare the scalar variable '@comment'. But I thought I did define it.... ====================================== CREATE PROCEDURE dbo.StoredProcedure1 ( @rating int; @comment nvarchar(1000); @tutorial nvarchar(50); @...more >>

Does anyone have a sample of this form I could use? We're moving to a custom CRM package written in .NET and I'll be handing the maintanence of the CRM. I need to start developing a procedure for request for changes because currently it's all informal. The requests would be anything from ...more >>

Main Point: Views I have on my 64bit server will UNION ALL to my 32bit server to gather core data. The 32bit server view needs some staic data (CountryCode) so it INNER JOINs back to the 64bit server to get the staic data. This is extremely slow. On my 32bit => 32bit server it works fine, but ...more >>