Answer Questions

• Mimuka Urgent!! SQL Restore problems

  Hi, Can someone please help urgently. I have a number of databases that I have set maintenance plans for. I am trying to restore these databases by using a stored proceedure. It was successful on my testing server, but when i try it on the production servers i have an error: Server: Msg 913, Level 16, State 8, Line 1 Could not find database ID 65535. Database may not be activated yet or may be in transition. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. If I do the following on the production machine it works: RESTORE FILELISTONLY FROM DISK = 'E:\SQL_TEST_Restore\CPROD_db_200608220410.BAK' restore database CPROD FROM DISK ='E:\SQL_TEST_Restore\CPROD_db_200608220410.BAK' ...Show All

• SLV Data Flow Task empty after check in

  On my office PC I have a strange problem with Data Flow Tasks. When I check-in a package into Source Control (Team Foundation) I usually have some empty Data Flow Tasks in the packages...even if I haven't changed that Flow Task. This is really frustrating cause when running the package all goes well, but after a whil you notice that some tables are empty. Does anyone know what the problem is Pukmaster wrote: After your message I just compared the real XML in the packages....and the Data Flow Task is really gone in XML. So, it's not a binding issue. Yeap, That's exactly what I found as well. Pukmaster wrote: After your message I just compared the real XML in the package ...Show All

• kenny125 retrieve the value that occurs the most

  Hi, I am trying to retrieve the value that occurs the most at a dimension level. For example, I have to analyze the product type mostly used in a specific target segment by number of products. The mathematical function normally used is MODE. However, in AS2005 there is not such function. I tried to use TopCount but it is not as easy as I thought. Any suggestion Thanks! I think TopCount would only get you a mode if you were to use it against a count measure. I am guessing that you want to find out which member from the product dimension has the most transactions against it for a given set of criteria. Depending on the granularity of your dimensions you may have difficulty doing this wi ...Show All

• D.V.Sridhar Can not remotely connect to instance of sql server 2000

  I had a big problem on connecting sqlserver remotely from other machines on the network ..... From any computer in the network i wanna to register the instance of the sqlserver from the enterprise manager ..... the server instance doesn't appear within the available sqlserver list (the servername which equal to my machine is the only one that appear) ..... when i manualy write the servername\alias manually and i choose the connection type and then i write sqlserver username and password and then finish he give a message to me that access denied or sql server doesn't exist ... !! by the way from the local machine i registered the local instance of sqlserver successfully and successfully i access the Databases ..... To be noted: ...Show All

• AksaiGora Image .BMP only shows on first page, place holder on the rest

  I am printing a batch of Explanation of Benefits and the image only shows on the first page for each person. If they have additional pages all I get is the little red X. Thanks, Phil I'm afraid I'm still not clear on exactly what you are trying to do in the report and how it's set up. based on your comments i can only guess that you have a parameter who's value you are using to display an image. Is that correct You'll need to post some more details about the report setup. This should work fine if you: Put the image in the report header remember to deploy the image to the report server   I wasn't clear on that from the initial post. It really depends on the report layout. ...Show All

• MatthieuGD change data format in stored procedure

  Hi All, My scenario is that I want to change the default SQL server format in my stored procedure more preferably only during the course of stored procedure execution (not permanent changes does any one have idea that how will I able to achieve this simple task... regards, Anas You can use the CONVERT function for this. As a common approach Date formatting should be done on the client and only on the server if you have no client application or the client application does not support it. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Webbee Stored Procedure Input Parameter Drop Down

  Hello, I have a stored procedure which has input parameters that must be entered manually. When I run the procedure from SQL Server Mgmt Studio, I type the entries into the appropriate entry boxes that appear. Is it possible to create drop down lists that include the allowed values, such that when I run the procedure, I can select the values from the drop downs, instead of typing them in each time Thank you. OK, thank you. Unfortuantely, the functionality you seek is more suited to client applications, and SSMS is not intended to be a client application -more of a management tool. You could relatively easily create an Access or Visual Studio based application t ...Show All

• Philippe Cand Reinitializing Push subscription after it expired in Transactional Replication

  I am using SQL 2000. How can I get my transactional replication reinitialized after it has failed with several attempts. I know one way of doing it through enterprise manager and specifying the subscription to reinitialize. But this will apply the snapshot and will take long time. Is there a fast way of doing it -Nipul A reinitialize requires reapplying the snapshot. Can you be more clear what you're trying to accomplish I think what you want to do is just restart the distribution agent, does this work ...Show All

• LordZoster running ssis package with a remote sql agent?

  hi all, thanks for the valuable information all the time!!! saved me a lot of time... our team developes a system for text data improvement using ssis . we have a few heavy packages that we want to execute on two separate "SSIS servers" that will be dedicated to runnung these packages only, and repeatedly. the main sql server will be placed on a different server machine . my question is: what is the best way to do this if we schedule these packages as a job of the Sql Ajent- does that mean that the packages will be executed on the sql server machine (which is not what we want) or could we define a remote machine to run the package on, and specify our "SSIS servers" or- should we use a simple scedua ...Show All

• Alanu data from one table into another

  I have searched for this answer without success, probably not hard enough. I want to take the data from one field in a table, and place it in another field in another table. c# Database1.InsertCommand = "insert INTO I just want the id in table one to be put in table 2 That much depends on the rows where you want to transfer the values to already exists on the other table (then you will have to do an update) UPDATE SomeOtherTable SET SomeColumn = SomeTable.Id FROM SomeOtherTable INNER JOIN SomeOtherTable Sot ON SomeTable ST Sot.SomeColumnToJoin = St.SomeColumnToJoin or the rows do not exists yet INSERT SomeOtherTable (SomeColumn) SELECT SomeColumn FROM SomeTable HTH, Jens K. Suessmeyer. --- http://www.sqlserver ...Show All

• Grmplse Two report parameters: "Please select a value for the parameter...."

  I’ve build a report with Report Design. On this report I want to show the items customers bought. In this report I added a Report Parameter so the user can select a specific customer. I made an extra dataset and use the filter =@customer and this parameter works fine. Then I want to ad a second Report Parameter: the salesperson. When I leave one of the parameters blank, I get an error "Please select a value for the parameter....". Even if I choose the options allow blank or null values, I get this error. What I want is de possibility to get all the records, to filter records from one specific customer or to filter records from a specific salesperson. Hi If you want the the filter to be &quo ...Show All

• kun123 fn_virtualfilestats doesn't work

  Hi everyone, Primary platform is Sql2k. I'm trying this sentence: SELECT * FROM::FN_VIRTUALFILESTATS and from our production server doesn't return results. Why the hell not However from other servers it returns data. Is needed to enable any feature for that Thanks for your time, Try this select * from ::fn_virtualfilestats(@var, -1) and see what is the results. Any idea about this odd behaviour Is there any difference in service pack or tools in between those server KBA http://support.microsoft.com/kb/290916 fyi. Hi Staya, It works now! TIA, 'suppose that the last time there was a huge workload for that server.. Glad to know that, I don't think that should have af ...Show All

• Michael Herman - Parallelspace insert image into database

  how to insert n image.jpg into the database what should be insert query Oh really , i have also heard of it once that its better to store the path ,,,, i think it would be more convenient to store the path .... LOL Jester, too funny. You know that you just put the hex value of " D:\desktop\05022006\free_chart1.gif" into the db, and not the image itself, right Hi, It stores the value in this format only for image.... but this is not a best practice, you should rather store the location of the files / images only and rest work should be done from the Front End Application so that you want lagging behind performance p ...Show All

• Margaret H What tables have extents in FILE X

  Hi How can I find out what tables have extents that are occupieing a certain file I added a file by mistake and want to delete it from a file group but a table has already thrown extents in to it. I would like to identify the tables, back them up, delete them, delete the file and then import them back in Thanks for your help I have already looked at both of those and they do not tell me what files a table resides on. i.e Physical file A, C in FILEGROUP XYZ I want to see an actual map of where a tables extents reside. I was also using backup in the general sense "Taking a backup" not actually using SQL Server backup utility as this doesn't backup individual tables. ...Show All

• ManjuVijay ASP Update Method not working after a MSDE to MSSQL 2005 Expess Update

  The Folowing code is not working anymore. (500 error) Set objRS = strSQL1.Execute strSQL1 = "SELECT * FROM BannerRotor where BannerID=" & cstr(BannerID) objRS.Open strSQL1, objConn , 2 , 3 , adCmdText If not (objRS.BOF and objRS.EOF) Then objRS.Fields("Exposures").Value =objRS.Fields("Exposures").Value + 1 objRS.update End If objRS.Close The .execute Method works fine strSQL1 = "UPDATE BannerRotor SET Exposures=Exposures+1 WHERE BannerID=" & cstr(BannerID) objConn.Execute strSQL1 W2003 + IIS6.0 Pls advice Hi, do you get an error back Which one The normal update should work like in the old server. HTH, Jens K. Suessmeyer. ...Show All