Sunday, March 17, 2013

[SQL Server 2008 issues] Upgrading/moving datbases frm 2005 to 2008

[SQL Server 2008 issues] Upgrading/moving datbases frm 2005 to 2008


Upgrading/moving datbases frm 2005 to 2008

Posted: 10 Mar 2013 04:17 AM PDT

After moving databases from 2005 to 2008, do we need to do run any queries (like update usage which we do in 200o to 2005).I will change frm 90 to 100 after necessary precautions. aything else i am missing?

Data not inserting

Posted: 16 Mar 2013 12:20 AM PDT

Hi i have written a query to check the insertion but its not working neither getting any error :Declare @valuebased varchar(13)='0000000000'Declare @valueDiscount varchar(13)='0000000000'Declare @ProductDiscount varchar(13)='0000000000'Declare @IsBooklet BITDeclare @vouchertypeid int, @voucherno varchar(13), @denomination int, @createddate datetime, @expirydate datetime, @voucherstatus int, @quantity int, @isbookletid bitIf @IsBooklet = 1BEGIN DECLARE @count int SET @count =1WHILE (@count < 10) BEGIN SET @voucherno = 'VVB'+CONVERT(varchar(10),MAX(@valuebased)+1) INSERT INTO GV_Voucher (VoucherTypeId,VoucherNo, Denomination, CreatedDate, ExpiryDate, VoucherStatusId, TransactionID, Quantity, IsBooklet) Values (1,@voucherno,10,GETDATE(),GETDATE(),1,'a1',12,0) SET @valuebased = @valuebased + 1 SET @count = @count +1 ENDEND

problem in execute the stored procedure

Posted: 16 Mar 2013 04:16 AM PDT

hii craete a SP in my database . by this command :USE [MyDatabase];GOCREATE PROCEDURE testAS SET NOCOUNT ON; SELECT id, feed1, feed2 FROM NFFeedsi can see this sp under StoredProcedure in my database .so...i write this command in Query :use [MyDatabase]exec dbo.testat this time a red underline appear under 'test' . if i set mouse cursor on it this error shows as a tag :"Could not find stored procedure 'test' "but if i execute the sp , it's execue normal and i can show the result . what this mean?

SQL Server 2008 R2 - Failed to connect to SQL Server

Posted: 16 Mar 2013 04:41 AM PDT

Hello everyone, I am having an issue and I am not sure why. I have every thing set properly I believe, I have an AD DC, The SQL Server is joined properly, I have the Server Action Account set properly. There is no Firewall on the SQL Server and the Server that I am trying to make the connection from is joined to the AD fine. The user account envolved is added correctly. It does btw have to be added local administrators group on the sql box for this app to work.I really do not want to re install all over again, also the named pipes and tcp/ip are enabled on the sql server, also the allow remote connections is enabled also.I don't know where else to look to fix this issue,The server envolved is a vm on an EXi 5.1 host w/2 gb of ram a 40 gb system drive, 40 gb data drive, 20 gb log file drive and 20 gb PageFile drive. I hope that is enough information. Sorry guys my kb has some keys that stick so I make typos occasionally. Thanks in advance,

Adding to Sales Quantities

Posted: 16 Mar 2013 03:23 AM PDT

Hi I have a table that forecasts our Sales for the upcoming year. It contains the following columns: Year (DATE), Company (VARCHAR), Product (VARCHAR), ProductType (VARCHAR), LastYearsSales (INT), ForecastSales (INT).I would like to increase the ForecastSales for particular ProductTypes in the table. So for example for all the LEISURE products I would like to increase the forecasted sales figures by 1000. I don't want to add a 1000 to each LEISURE product but share the 1000 over all of the LEISURE products ie if there were 10 LEISURE products in the table then increase each of their sales by 100 (1000/10). Thanks in advance.BO

Changing passphrase for EncryptByPassPhrase

Posted: 15 Mar 2013 10:48 PM PDT

I am using EncryptByPassPhrase(http://technet.microsoft.com/en-us/library/ms190357(v=sql.105).aspx) for encrypting some columns . But if i want to change the passphrase in future then how can i change it?

Issue in JIRA

Posted: 15 Mar 2013 10:59 PM PDT

Need help on JIRA ,i have created one Subtask for an issue in JIRA but now i need to remove the sub task i am unable to find the option delete ,could anyone help me on this

No comments:

Post a Comment

Search This Blog