Search results for query: *

Hi I need to export just the app roles from one db to another... please is urgent !!!!! thanjk a lot...

I have a DB mssql server 2000 that works with application roles. I need to read some data from an asp.net page, but I don't know how. I know this is not the correct forum, if somebody can help me, it will be great. regards. cmn

Hi dear friends !!! I need obtain a return value from a function. In this function, I work with a query built dynamically, from which I get the value. So the thing is: DECLARE @X INTEGER DECLARE @STRING NVARCHAR(4000) SET @STRING='SELECT COUNT(*) FROM MY_TABLE' EXECUTE(@STRING) i need to...

Hi, I've a table with a IDENTITY column, when I execute "SELECT IDENT_CURRENT('mytable')", this statement returns 161. Now I wanna change this value (for example,to 100). I'm sure you masters have an answer for this. Thanks in advance Regards

Hi, I've some Sql code with a INNER JOIN for two tables. I put this code inside a Stored Procedure. This SP has 2 parameters (varchar both) that work like filters. When I run the SP sending the parameters, this takes up to 2 minutes for the results. When I execute the same code but now with 2...

I wanna make a report in Crystal Reports 4.6 using a store procedure from SQL SERVER 2000 as datasource. This SP was made with dinamic code, and has 4 paremeters. At the end of the SP, I wrote "EXECUTE(string)", executing the code. In the Query Analizer(SQL S 2000) I don't have any problems, but...

hi, i have a problem with my sql server connection. we have some .net aplications running over SQL SERVER 2000 and Windows 2000. Sometimes, I get this error message: "Cannot generate SPPI context" when i wanna open the query analyzer. The same thing occurs with this aplications, the conection is...

hi everybody, I've the next statement: SELECT DATEDIFF(YY,'1977-11-15',GETDATE()) The difference between the 2 dates, in years, should be 27, but it returns 28. ¿ what's going on ? Regards

hi, I need to print from a vb.net form directly to my printer ( dot style). I wanna print a lot of data, and don't need a page jump in every page I make. I try with the 'printdocument' object ( graphics.drawstring...) without success. Thanks in advance

hi, I've a problem with the OPENDATASOURCE function. I wanna open a .xls file on QA but just can't do it. ¿ anybody with a idea or solution ? a lot of thanks in advance. Regards, CMN

hi everyone, i need some help urgently....the situation is this: I've made a backup of my database in the Enterprise Manager, but when I want to restore it in another machine, it said that the "back up is off line or there is a device error".... ¿ what i'm doing wrong ? any suggestions will be...