Answer Questions

• jk67 Seek in a SQL table from Access

  I have an MS Access 2003 database from which I want to seek a specific record in a SQL Server Express 2005 database. I can connect to the table and get a recordcount but the recordset.supports (adseek) and recordset.Supports(adIndex) both return false. Any suggestions Specific code I'm using is as follows: Dim cnxn As ADODB.Connection Dim strCnxn As String Set cnxn = New ADODB.Connection cnxn.Provider = "sqloledb" strCnxn = "Data Source=SERVER\SQLEXPRESS2005;Initial Catalog=RAMPSQL;Integrated Security='SSPI';" cnxn.Open strCnxn Set rsWSC = New ADODB.Recordset rsWSC.CursorLocation = adUseServer strSQL = "DailyData" rsWSC.Open strSQL, cnxn, adOpenKeyset, adLockReadOnly, adCmdTableDi ...Show All

• Dave Chong Problem Connecting to SQL Express (error in initializing provider)

  I have seen several posts on the subject, and have tried various configs. At this point, I am simply trying to connect to SQL Express, that's all. I have an app. in MS Access that uses SQL Express as a back-end database (this is the simple desktop version of our software). I don't remember having so many issues with just connecting to a small db engine on a single computer..! Just to get it off my chest, there was a post about this subject where someone listed more than 15 items to check... If anyone at Microsoft is reading... connections should not require a 15-item check-list.. People running sql express are not creating a sophisticated database system, probably running it because, they want a free, easy solution, and do not have an ...Show All

• aquaseal New problem getting data from xml table in sql db (Newbie)

  Hello, I have this xml tablerow in a table in my db. 2 examples <Toyconfiguration version = "1" name = "Lego"> <Ballconfiguration version = "2020" name= "Adidas"> If I would want to get the name of the toy or ball I would write Select Tablerow.value('((@name)[1]', 'varchar(100)') From table This would return Lego and Adidas But what if I want to know which kind of configuration it is How do I do this The answer I want is Toyconfiguration and Ballconfiguration.. Any help would be appreciated! You could use local-name() function: select Tablerow . xml_col . value ( '(//@name)[1]' , 'varchar(100)' ) ...Show All

• NeederOfVBHelp sql server 2005 database tuning advisor how to use it on full database[not a single table or query].

  I want's to sql server 2005 database tuning advisor.To see the possible tuning on a full database.[not a single table or query]. I haven't use this utility before.When I try to run it it ask for a table or workload file. How can i run Database tuning advisor on whole database Can I do it or not  True, it is the best place to start on the new topics. Also review http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx , http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1161285_tax301334,00.html adg=301324&bucket=ETA See SQL Server 2005 Books Online topics: Database Engine Tuning Advisor Tutorial How to: Tune a Database by Using Database Engine Tuning Advisor Using Database Eng ...Show All

• preed_lahey is it posible to put more than 4000 bytes into one column? ( sql server mobile )

  varchar can only hold 4000 bytes and there is no text column in sql server mobile Hi, try 'ntext' Pete I'm having the same issue. I checked through the designer code and found the max length set to the correct length for ntext (536870911). Just to be sure I recreated the database and the dataset, but got the same result. I think this might be a genuine bug. I'm using SQL CE 3.5 with VS 2008 Beta 2: I have a table with some coulmns of NTEXT type, but when i want to update my dataset to database with a row which has that field more than 4000 charachters I got this error: "InvalidOperationException was unhandled @p4 : String truncation: max=4000, len=4 ...Show All

• yem Applying colors to reports

  Is there a way to apply .css or Skin files to all reports. Changing colors in each and every page is a little cumbersome. Thanks in advance We have been looking for the same thing, finally we did put our colors (textual) in a database-table and assign text and background colors with an expression, causes some work to do, this for earch report but once done, you can change al your reports depending on the season or whatever crazy reason to change layouts. Even our header images come from a database so during some periods we can (just like google) do some funny stuff. Users mostly appreciate it. How about creating a custom assembly and putting your formatting ...Show All

• The ZMan Textbox Properties Format Code = to General Format in Excel?

  When I export a report to Excel I need most of the fields to be the general format of Excel which is what in the format properties of Reporting Services Reports I tried Default and that doesnt seem to be it either. According to Excel the General format cells have no specific number format. Any ideas would be wonderful! Thanks so much! Stokh :) I have tried everything, from it being in the sql select Oca_Cd,Convert(char(30),cast(DebtorName as text)) as DebtorName ,Convert(char(20),cast(AccountNumber as text)) as AccountNumber, DebtorPhone,Convert(char(15),cast(Msd as text)) as Msd ,Lob,IndOrgBalance,EnterDate,TransAmt,TransType,TransDate,GrossComm, EdiTransDate,Tax,TextId,ImportDate from temp_verizon_info where TextId ...Show All

• Febin Execute As error

  I have a stored procedure that needs to run with elevated privliges, so I tried setting it to run as one of the db owners. When a regular user tries to execute the SP, I get the error Cannot execute as the database principal because the principal "joejoe" does not exist, this type of principal cannot be impersonated, or you do not have permission. What do I need to set up so a user can be impersonated Can you post a quick repro of the code you used to create the user, and to execute as You might just try: execute as user ='dbo' Since that is the dbo. Or execute as SELF, if the object is owned by DBO. I've also tried granting impersonation privliges to doolitle. That didn't help either. I need ...Show All

• Whoisit upgrading to sql 205(jobs and deframent script)

  Hi I am moving to sql 2005. I need to have info on how to have my jobs running in 2000 to be in place for 2005. --- Should i re-create each  job.Is there any other method Is there a way like i can script my job in 2000 and have them done at 2005 --- i am using scripts which does Deframent index ,index rebuild and update stats in sql 2000 .Can i use the same scripts in sql 2005. Kindly advice on this Thanks in advance     As you did not mention which functions you are using to do the jobs, this should be worth a try. If you have a test system, try to execute the scripts which are created on the 2k box on the SQL 2k5. If functions are deprecated or obso ...Show All

• Deza .NET FW SDK QuickStart SQL-Express Error: Msg 102 ... Incorrect syntax.

  Hi, I have followed the steps from the .NET FW SDK QuickStart Configuration (C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Samples\Setup\html\ConfigDetails.htm), and have got an error message trying to grant the ASP.NET User account access to the databases by the command sqlcmd -E -S (local)\SQLExpress -Q "sp_grantlogin LEONEW\ASPNET" where LEONEW is my local machine name, and the ASPNET account exists in the Users group. I am getting the error message: Msg 102, Level 15, State 1, Server LEONEW\SQLEXPRESS, Line 1 Incorrect syntax near '\'. Please help if you know how to resolve this. Thanks in advance. Alex. I have tried with no success sqlcmd -E -S (local)\SQLExpress -Q "sp_gran ...Show All

• andycsuf The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

  I know that another thread dealt with this error message before but after trying all the suggestions of that thread without success, I thought my problem may be different. I have SSRS 2005 installed on my local machine (TAH112) and it worked flawlessly for months. Suddenly it stopped working today. The Reporting Services Configuration tool shows everything is normal (green buttons all the way except for encryption keys button that is blue and Execution Account button that is yellow). When I try to connect to the server with SSMS, I got the following error: TITLE: Connect to Server ------------------------------ Cannot connect to http://tah112/reportserver . ------------------------------ ADDITIONAL INFORMATION: The requ ...Show All

• Sunil Dutt Comparing strings in MDX

  Hello gurus, Is there an equivalent to the TSQL LIKE '%mystring%' function in MDX e.g. to filter a Product dimension to only those products containing 'IPOD' or whatever Thanks Mosha, How nice to hear from you. I was at a talk by Chris Webb last Saturday and he was singing your praises. As I have been fumbling with MDX for the last couple of months I bought your Fast Track book this week because I feel I have been trying to run before I am fully clear on the basics. The sprocs you mention look like a very useful extension to MDX, though I note that they are not recommended for a production environment at the moment. Vladimir's suggestion of using InStr seems to work fine in this case. Thanks Yes, there ...Show All

• Bob Pokorny SQL Server 2005 Backup Through management console

  Hello Everyone, I have configured sql server 2005 for daily backup through its management console. Everyday backup is taken just fine without any problem. now i have configured its maintanace clean up task to delete the files which are older than 3 days at the time of writing file to specific folder. But some how this is not working and no files are deleted since i have configured this one week before. can you please drop your suggestion how do i need to configure it again so it can clean up the files according to the maintanance cleanup task. I would appreciate your help on this. Thanks, Bharat what is the service pack applied on the system... there are some issue ...Show All

• kcchesnut Problem in trigger

  hiii i am creating a trigger for insert ona table in .net and in that trigger i want that send a mail thrugh that trigger, and when i insert a record in that table in sql 2005 then the error comes this , plz tell me solution for this (14 row(s) affected) Msg 6522, Level 16, State 1, Procedure CalculateResult, Line 1 A .NET Framework error occurred during execution of user defined routine or aggregate 'CalculateResult': System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. System.Security.SecurityException: at System.Data.SqlServer.Internal.ClrLevelContext.get_WindowsIden ...Show All

• Amit Bansal Problems importing a datetime from a flat file

  I have a flat file with a datetime field as follows 12419,1,'T','P',229.72,2,'N',2004/may/05 19:47:42.546001 12419,1,'T','R',605.38,76,'N',2004/may/05 19:47:42.546000 12419,2,'T','P',110.49,2,'N',2004/may/05 19:47:42.546003 12419,2,'T','R',215.53,11,'N',2004/may/05 19:47:42.546002 12419,3,'T','F',9.29,1,'N',2004/may/05 19:47:42.546005 12419,3,'T','R',696,38,'N',2004/may/05 19:47:42.546004 I can NOT get last field i.e. the date time field to import into SQL werver 2005 using import wizard. I can manually enter the value in the table so I know it can handle data in the format it is in.. (table field is date time) but I cant get import wizard to read the file and bring in the data.. It bombs at coloumn 7... which is the date ...Show All