Search results for query: *

Hi all, I have MS SQL 2005 Standard installed. Running on Windows 2003. 16GB of RAM I understand that in 2005 they changed memory management so that they would not have an issue with O.S. Ram memory being relinquished by SQL server. in 2000 it never gave memory back to the O.S. until you...

Hi I hope you can help. My sql server 2005 (CLustered, active active) running on an MSA disk array has been working fine, all of a sudden the simplest of queries, i.e. SELECT COUNT(1) FROM tableA spikes the CPUs (there are 8 in there). With 8Gig of Ram to use. I have checked execution plan...

Hi I have a virtual Box where i want to build a SQL Server 2005 instance. This is going to be licensed using per processor licensing. currently starting at 2 processors. How easy is it to tell SQL SERVER 2005 to use additional CPUs if I change the processors to 6 processors on the box. i.e...

Hi I am having a weird problem RUnning both UPDATE STATISTICS <<table>> WITH FULLSCAN and sp_updatestats both dont change the modCtr column in Sysindexes for that database. Does anyone have anyideas??????????? Even a re-index of the table doesnt shift the indexes on my tables Any ideas

Hi I am currently running SQL Server 2005 - Standard in a cluster and want to replicate this out. I do need to keep the subscriber in sync all the time (Live). I dont want to use the in-built SQL Replication as I think it is resources intensive and they havent got it right. Database is highly...

Hi This is really really annoying, I have checked on Microsoft website and other forums about this apparent problem with maintenance tasks, or just generally anything that is scheduled via SQL SErver Agent going out of sync or jobs for no reason running twice, i.e. my backups are running twice...

Hi I am having a problem with a 2000 backup of a database made on a sql 2005 server. The database was created as a 2000 database on 2005 box. I now want to back it up and restore it on a 2000 box, however I get an error of compatibility. Is their anything else i can do?? I have set the...

Hi I have upgraded my cluster environment SQL SERVER 2005 Standard from SP1 to SP2 (4th Apr 2007). I am getting the following strange errors on the server, i. Management Studios - trying to open the Maintenance Plan to see the backup plan, not possible error: Value set to NULL, unable to...

Hi One of the team ran an update statement trying to update 30mm rows. Bad Idea I know, but he wasnt to know the consequences of it. It ran over night and never finished. Were not rolling it back by executing the kILL command against the process. However, we are getting no timings on when it...

Hi I am running a simple loop statement that deletes data from a table however it needs to be ran in a loop. I need to let it run in a high level of isolation level SERIALIZABLE WHILE @t <= @Max BEGIN SET TRANSACTION ISOLATION LEVEL SERIALIZABLE BEGIN TRAN DELETE FROM TABLE a DELETE FROM...

Hi I need to do some performance benchmarking on 64 vs 32 on SQL server 2005. Is there a good website or sites where I can find this info out which will hopefully show that 64bit is the way forward ?? Thanks Sanj

Hi A very quick question, like you have in Enterprise manager you can right click a database and then choose all tasks and Generate scripts. You get a window to choose all the objects you want to script out. Is there anyway you can do that using osql?? is their some SQL built in stored...

Hi can I do this in SQL SERVER 2005 INSERT INTO LocalServer.LocalDatabase.dbo.#Temp EXEC REMOTESERVER.RemoteDatabase.dbo.storedprocedure_test The stored proc when ran like above never completes but if I just run the stored proc like below EXEC...

Hi I am wondering is there a work around for the SendMail Task BCC property in VB Script (ActiveX task). Does it exist? Is there a work around? Thanks for your help Sanj

I have the following piece of code. I am making it error by having an unknown table BondquoteArchive to see if the transaction gets rolled back, however it does not. Can anyone see why???? Thanks DECLARE @ErrorCounter INT SELECT @ErrorCounter = 0 BEGIN TRAN INSERT INTO...

Hi I have the following loop to execute a command in a temp table Code: ------------------------------------------------ ---------------------------------------------- -- START LOOP ----------------------------------------------- WHILE @Counter <> @MaxRow BEGIN --Execute each Row SELECT...

Hi Im a beginner at ASP.NEt with C# I have a page and what I want to do is that once I add using form controls information regarding a particular subject. I want to reload the page and in the url pass a unique id and this will then load a grid up. I have the page load class written I have...

Hi there I have an interesting question, which Im sure you guys can answer. I have a set of data Which has some duplicated data. e.g. EntityId CurrencyId Bid Offer Context 1 1 12 34 sdfasdfasdf 1 1 14 30 asdfasdfasdf 2 1 56 89...

Hi this might be very basic but I have a quick question Im trying to do the following, PRINT '***********' PROMT 'key: ' + SELECT * FROM #Instrument PRINT '***********' Im hoping to get it to come out like this: ********** Key: 23434343 234234234234234 234234234 ss24323423...

Hi there Problem with the code recognising the second field and returning its values not nulls. If I set rs.Fields(0) then the first field of the data is selected with its correct value. If i change this to anything other than 0, i.e. 1 to get the second field, it only gives a null as its...