I'm trying to profile the experience of multiple users of a web application, all trying to generate reports at the same time. The reports are displayed on a web page using the report viewer control. The execution log on the report server seems to indicate that the reports are executed sequentially (one at a time). Is this the expected b...
I need to export database from SQL Server 2005 to SQL scripts (like we can easily do in MySQL). So I want to get generated file with scripts like this INSERT INTO ... [row 1] INSERT INTO ... [row 2] INSERT INTO ... [row 3] ... Can anybody explain how can I do this step-by-step? ...
Hi There, I have a couple of ms sql server (2000) stored procedures encrypted by ex-employee long time ago and things were okay until we need to change it a bit.... is there any way at all to retrieve the source? Or rewrite is the only option? Thanks a lot. ...
Hi! SQL Server question. When doing INSERT INTO T1 SELECT (C1, C2) FROM T2 I don't want to specify column names of T1 because they are the same as in T2 Is it possible to do so? Currently I'm getting error Msg 213, Level 16, State 1, Line 1 Column name or number of supplied values does not match table definition. ...
i have a webbased tracking application and i am storing data in SQL server. I am tracking which locations i have deployed applications. The web interface is a dropdown combo and I have a varchar(100) field right now. I have the user select a dropdown list: Global America Europe Asia but now i have applications that are stored in m...
Hi, My data type in database is of type money, the problem is when I save value from user entered input (via a text-box) its not what I expected. Example : string price = "199.99"; in the table it would save as 19999,0000 I tried Convert.ToDecimal("199.99"); and Convert.ToDouble("199.99"); the result is still the same. What sql server da...
Hi As I am new to SSAS,have been reading an article on Multi-Dimention OLAP Cube and struggling to understand Cube concepts, It has been said that Although the term "cube" suggests three dimensions, a cube can have up to 64 dimensions. Could you please explain how is this possible on cube (other than 3-Dim example x,y,z planes)? Please...
I've the two following queries: declare @UserId as int set @UserId = 1 -- Query #1: Sub-query SELECT u.[Id] , u.[Name] , u.[OrgId] AS Organization, (SELECT o.[Name] FROM Org o WHERE o.Id = u.OrgId) As OrganizationName, [UserRoleId] AS UserRole, [UserCode] AS UserCode, [EmailAddress] As EmailAddress, (SE...
Hello friends, I have a website with pages having GridView in it. I am using SQL Data Source control to bind with the GridView. After running the site i am checking the no of active connections with SQL Server using - SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE...
Can anyone tell me what data providers are installed by default on windows xp and above for accessing sql server, im looking for (and hoping) that there is a common OLEDB provider, or sql native provider that i could use (for performant reasons ODBC is out of the running) The intended provider must be installed by default as a requiremen...
I have the following query that gives me an extract (I am putting this into a CSV from my cube). I want to show the Total of all NRx in a column as the first column NRx and the rest of the NRx columns should come up as they do now. I tried to add a SUM (Measures.NRx) to this, but it did not work How do I get a Total NRx column? SELECT...
Hi, I have a website that has product names containing French and English words. When I store a product name I store it as html encoded in the ProductName field in my SQL Server. For example the word Château is stored as Ch& #226;teau in my database. If someone wants to search for a product name I htmlencode the search term. This will ...
how does sql-server handle infinite loops? Does it detect it or kill the server. EG: WHILE (@number = 3) BEGIN print @number END ...
I have a MS SQL 2008 database which stores data for creating a weighted, undirected graph. The data is stored in tables with the following structure: [id1] [int] NOT NULL, [id2] [int] NOT NULL, [weight] [float] NOT NULL where [id1] and [id2] represents the two connected nodes and [weight] the weight of the edge that connects these nod...
After installing SQL Server 2005 (with SSNS, SSIS and SSAS) I found Office Web Components (OWC) installed as well. My customer is asking why OWC is required I have nothing to say. Any ideas? Is there any additional licensing requirement? ...
Hi, I have a application that uses LocalDataCache to synchronise a SQL Server 2008 Express database to a client database (.sdf file). This works great and I am now managing the conflicts. I am using this Microsoft resource as a guide: How to: Handle Data Conflicts and Errors The conflict I am particularly interested in is ConflictT...
hi *, I need to trace changes on a record in database. I have some triggers on different tables that calls one stored procedure and this sp updates records in certain table (table1). I will trace records in table1 to find when and from where data are changed. Actually I use sybase 12.5 and I would know how to read LOG file by SQL qu...
I have a for xml raw select query that returns a xml string in server2005 and i would like to write that string to a file using vb.net. ...
Hi All, I'm using Java 1.6, JTDS 1.2.2 (also just tried 1.2.4 to no avail) and SQL Server 2005 to create a CallableStatement to run a stored procedure (with no parameters). I am seeing the Java wrapper running the same stored procedure 30% slower than using SQL Server Management Studio. I've run the MS SQL profiler and there is little...
I want to display date time as eg. Dec 1, 09 11:22:45 PM using SQL query Currently my format is : DATENAME(Month, (((MachineGroups.TimeAdded*10000000)+ 621355968000000000) -599266080000000000) / 864000000000) + SPACE(1) + DATENAME(d, (((MachineGroups.TimeAdded*10000000)+ 621355968000000000) - 599266080000000000) / 864000000000) +', ' ...