Answer Questions

• jomunoz Unable to backup or restore SQL 2005 database to desired drive

  Does anyone know why I would only be able to see 1 drive out of the 4 on the SAN from within Management Studio I am on Windows 2003 and SQL 2005 sp1 installed on a cluster. My sysadmin set up 4 drives (S:Data, R:Backup, L:Logs, T:Temp) and claims I am using a domain account with all the privileges I need to be able to see these drives. However, when I log in as sa and try to create a backup I can only choose the S drive. Oddly, I can type in the R drive and it will write to it but I am unable to see it. When I try to restore from the R drive I get the error: Could not resolve specified location. Either the location does not exist, or current login does not have access to it. Any thoughts on this would be greatly appreciated. Than ...Show All

• zenzai how to get error message

  Hello! I am using T-SQL (SQL Server 2000). I would like to get error message (for example stored in some string variable) when error appeares. I found only system variable @@error which holds the error number of the specific error. But I didn't find any way to get a message which is written in SQL Qery analyzer in the Message window beneath the query window. Is it possible to get that message somehow I would like to store it in my error table... Thanks a lot, Ziga Thanks a lot! But anyway I would like to get the same message as is reported in sql server (with object names - attribute name). Systables contains attribute description with description of the messages with placeholders. I ...Show All

• Javahar Rotation of Column Headings in a Grid Report

  Is there any way to specify that you want a column heading rotated to 45 or 90 degrees I have a grid report with single character values in the grid but the column headings are very lengthy so the resulting report is several pages wide. I'd like to be able to rotate the column headings 90 degrees (this is easily done in Excel) to get the report to fit on a single page. Change the textbox WritingMode property to tb-rl. Sorry, no tb-lr yet. ...Show All

• LouArnold how can i get this query

  Hi can anybody give me a suggestion to get result like Student Computer Geography Social ID Name ID SEM Marks ID SEM Marks ID SEM Marks 1 ABC 1 1 80 1 2 35 1 3 88 2 CDE 2 1 60 3 2 65 2 3 45 3 XYZ 2 2 55 3 1 67 3 1 75 and I want OUTPUT as below Name Com ...Show All

• JCJCJC problems at beginning of set up

  Before I get into the project that I actually need working I'm trying to get through an example or two provided by microsoft. I'm using the Flights sample from http://msdn2.microsoft.com/en-us/library/ms160889.aspx I've downloaded the files and follow the instructions but quickly ran into trouble. I select the configuration file, enter the needed information, check the 'enable instance after it is created' box, and click okay. This takes a couple minutes but finishes without errors. I then try the register step. I enter my login information for the computer I'm using and use windows authentication. After click okay here's the error I get: Registering Instance - FlightInstance - Updating registry entries (Success) ...Show All

• Nilkanth SQL Server vs. XML Configurations

  I have been experimenting with both XML and SQL Server Configurations. Management would really like to go with the SQL Server Configurations, but I seem to be having problems with them. The main goal is to be able to create a configuration for each connection and have every package refer to its specific configuration, therefore in the future we could change say our SA password and only have to update this in a few places rather than for every package. In order to experiment with the problem I am having I developed 2 identical packages, except one uses SQL Server Configurations and the other uses XML. The configurations save the exact same properties. With the XML package I can go into the configuration file and change say the passwor ...Show All

• DavidR100 Encryption Varbinary Length

  Using the new encryption included in SQL Server 2005, what is a good way to determine what length I should use for the column   For example, I am encrypting a column, its maxlength is about 30 characters, but when encrypted, the encrypted value extends from between 50 and no more than 68 characters- So if I had a column with a max of 500 or so characters, how could I know what varbinary length I should set it to if I were to encrypt it, without actually finding the highest value I could possibly fit into the field Is it good practice to just make it a varbinary(max) field -rob Raul, thanks for the reply. would a CLR UDF approach still use the SQL 2005's key/certificate infrstructure or i ...Show All

• Rensoc The Device is not ready error when Executing package on the server

  Hi, I have a package which reads an XML file from a certain folder and parses it. I deployed my package onto the server. Copied XML files on the D:\ drive the following folder on the server. Dim reader As New Xml.XmlTextReader( "D:\Apps\Request\Clients\ClientsStatus.xml" ) is fine. But Do While (reader.Read()) generates "The Device is not ready" I think it is still trying to read it from my desktop on which I don't have a D drive. Any help is appreciated.       I meant to post it to the SSIS forum.     sql agent is running as a domain user with admin privs to the file share. The driv ...Show All

• Mateusz Rajca Total hours calculation

  Hi, I'm new to Reporting Services, and I have to make a sort of timesheet-report out of a sharepoint list. The sharepoint list works great, employees give in their start, stop and lunch times, and the project they are working for. Now, on my report, everything looks great, except, I can not get the grand total of the worked hours. I think I need some function in my totalHours field, but I don't know how to write this. So I am looking for someone to help me write this, and I am willing to pay for it. Can anyone help me out Thanks in advance, Natascha I have tried that, but this does not work. My totalhours are in hh:mm format, the SUM function cannot handle this... ...Show All

• mike11d11 Debug is greyed out?

  I know there's a trick to this, that I can't figure out. Have an SSIS package that I developed and deployed/saved( ) to a file on the SSIS server. Now I need to change the data flows. Did that, no issues, lets me resave the file, but I can't debug or execute the package so I can test what I did is right Why is the debug drop down box greyed out There's gotta be something I'm missing here. THanks, Lezza Ahhh. Yes I was going straight into the 'recent' file instead of into the project. I have now unravelled the twisted knickers & my project & packages are once again showing me the love It needs to be part of a Visual Studio solution in o ...Show All

• JLB4536 Identifier! [problem in passing a lengthy string to an SP]

  exec sp_SearchProductAdvanced "(name LIKE '%a%' Or name LIKE '%b%' Or name LIKE '%c%' Or name LIKE '%d%' Or name LIKE '%e%' Or name LIKE '%f%')and (salesprice between 3 and 10) " ,null after executing i got this error: The identifier that starts with '(name LIKE '%a%' Or name LIKE '%b%' Or name LIKE '%c%' Or name LIKE '%d%' Or name LIKE '%e%' Or name LIKE '%f%')and (salesprice ' is too long. Maximum length is 128. how can i solve this problem. so that i can use more values . my lenght exceeds 128. is there any way to get rid of this. in my SP i have declared the parameter variable as @criteria nvarchar ( 1000 ) hi, thanks for the response. i go ...Show All

• AbhilashN Problem with Transaction Logs

  Hi, I have a big problem with transaction log. I need to reduce the transaction log file becouse, the have 25 GB, but when i run the statement for BACKUP LOG with TUNCATE_ONLY, dont work, becouse i have database mirroring installed. Please is very urgent. Hi Michael, My environment is this, I have a one Database with 3GB of Data. This Database is for management the purches orders of the goverment, so in this case, if the database is down, i need another in standby. But, the transaction log gowth to much in houres (25GB). When i do the shrinkfile only down a 1GB. Oh I also got this big problem, and I amazing that no MS SQL supporter answer this question clear. Perhaps this has been explained scattered ...Show All

• cythe MS JDBC Driver incompatibility with JDBC 3.0 specs

  Hi all, We've just stumbled on a 1.0 version incompatibility with the JDBC specs. Problem: A table with SMALLINT column. According to JDBC specs version 3.0 (p.B-179) and 4.0 (p.221)), the value should be converted to Integer type. Unfortunatelly we get a Short object :( Now, I remember, this case was also affecting old JSQLConnect driver from DataDirect. Could that problem sneak to new MS driver too Please let me know any resolution to this problem if exists. The issue has not been fixed in CTP 1.1 version. Any ideas if it can be fixed Cheers, Piotr Piotr: Thanks for your post. It looks like inbound and outbound cases f ...Show All

• Polity4h SQL Server Compact running in Windows Service

  Hi, On the page http://www.microsoft.com/sql/editions/compact/default.mspx  it is recomended that you dont use SQL Server Compact Edition if "you want to run as a service" - is this refering to the host application or to the fact the SQL Server Compact Edition is an embedded database rather than the more traditional SQL Server client/server architecture If its the former is this likely to change at any point in the future  Also what sort of problems are likely to occur if we did run it from within a windows service Many thanks, - James   *EDIT [Changed capitalization] Yes we *dont recommend* to run SQL Server Compact Edition as a service. I think SQL ...Show All

• Andreenkov Alexander ReportViewer Find

  I have a Local report bound to a R eportViewer control and when I am typing in text in the find text box and I click find I get this message on the report viewer "Object reference not set to an instance of an object" anybody have any idea This is a known issue with the report viewer control. It is fixed in Visual Studio SP1. See this posting for more information: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1032267&SiteID=1 ...Show All