Search Results

Search found 5101 results on 205 pages for 'ssrs 2005'.

Page 54/205 | < Previous Page | 50 51 52 53 54 55 56 57 58 59 60 61  | Next Page >

• how to forward engineer database diagram from visio 2003 file ?

  - by dotnetcoder

  I came across some vb macros that export it to a mdb ( ms access ) file. But does not work very well when copying forward constraints , etc. I want generate schema from the database diagram for sql server 2005 database.

  Read the article

• How do you extract just date from datetime in T-Sql?

  - by Grand Master T

  I am running a select against a datetime column in SQL Server 2005. I can select only the date from this datetime column?

  Read the article

• Do non-clustered indexes slow down inserts?

  - by mikeinmadison

  I'm working in Sql Server 2005. I have an event log table that tracks user actions, and I want to make sure that inserts into the table are as fast as possible. Currently the table doesn't have any indexes. Does adding a single non-clustered index slow down inserts at all? Or is it only clustered indexes that slow down inserts? Or should I just add a clustered index and not worry about it?

  Read the article

• How can I add a binary device driver in Platform Builder for Windows CE 6.0?

  - by Jaime Soriano

  I need to add a device driver to a Windows CE image, I have the driver in .dll and .reg files and in a .cab package. I'm using Visual Studio 2005 with Platform Builder for Windows CE 6.0. How can I do that?

  Read the article

• How to make the process quicker?

  - by dewacorp.alliances

  We build a system that handling the billing analyse and what it does it just have a raw bill from vendor and process to "common" table and this is using SQL Server 2005 Integration Services. At the moment, the batch has 300,000 rows and it took about 6 minutes to process. Now, the current spec are: 2 CPUs Intel Xeon E5345 @ 2.33 GHz RAM 4GB Is there anyway I can speed up this process?

  Read the article

• Bulk updation of sql server table using xml

  - by Nimesh

  How can i update bulk data in sql server 2005 by sending the data in XML form ? i am able to insert bulk data into the table, but i am not getting idea to update the data.

  Read the article

• WCF 3.0 Service Contract method will return 992 rows but not 993 rows. 50 column observable collecti

  - by Ferrell Carr

  Exact duplicate of: http://stackoverflow.com/questions/2845454/wcf-3-0-service-contract-method-will-return-992-rows-but-not-993-rows-50-column My VS.Net 2005 CF 3.0 WCF will has a limit on how much data it will return

  Read the article

• SQL Server Transactions how can I commit my transaction

  - by codingguy3000

  I have SQL Server 2005 stored procedure. Someone one is calling my stored procedure within a transaction. In my stored proc I'm logging some information (insert into a table). When the higher level transaction rolls back it removes my insert. Is there anyway I can commit my insert and prevent the higher level rollback from removing my insert? Thanks

  Read the article

• How to organize infinite while loop in mssql ?

  - by alpav

  I want to use infinite WHILE loop in SQL 2005 and use BREAK keyword to exit from it on certain condition. while true does not work, so I have to use while 1=1. Is there a better way to organize infinite loop ? I know that I can use goto, but while 1=1 begin .. end looks better structurally.

  Read the article

• bulk insert to SQL Server, insert statements vs one insert XML statement?

  - by Henry

  The application layer (ColdFusion) needs to insert multiple rows onto SQL Server 2005. I was thinking of using loop in app layer to construct multiple input statements and send to SQL Server over JDBC in a single connection. My colleague however suggests to construct an XML and bulk insert the XML instead. Which one is the better method?

  Read the article

• Hide Properties/Toolbox Pane when not in Resource View?

  - by theycallmemorty

  Every time I view a form or dialog in Visual Studio (2005) the Properties and Toolbox panes show up on the right side of my screen. That's good to have because they are useful for manipulating dialogs. However once I switch back to source code these panes just get in the way... is there a way to get them to go away automatically?

  Read the article

• tsql to know when a database was last shrunk

  - by Manjot

  Hi, In SQL 2000, 2005 and 2008, how can I know when databases were last shrunk on a MS SQL server? I want to do this using TSQL. Regards Manjot

  Read the article

• Is there a way to sort by more than one field in Crystal Reports?

  - by John at CashCommons

  I'm using Crystal Report with VB.NET in Visual Studio 2005. I have report that works if I pass in a list of List(Of Stuff). I had been sorting the report by one of the members of Stuff but a need now to sort first by one member, like Stuff.StatusCode and then by another member, like Stuff.ItemNumber. Can I do this just be having more than one SortField member, or do I need to do it some other way? Thanks as always!

  Read the article

• Tell SQL Server the error is "handled" in try...catch

  - by Restless Archer

  Hi. I'd like to indicate to SQL Server 2005, in my BEGIN CATCH...END CATCH block that the error is "handled"... That is, clear the error. Is that possible?? Thanks. A.

  Read the article

• Native XML WebService With Authentication Basic and SSL

  - by tom

  I'm using 2005 and the Native XML WebServices. The integrated authentication via HTTP:80 works fine. But i need the basic authentication which requires SSL. So if i change the web service to ssl i always get a connection reset (101). I tried several ports 80,443,9999 with the same outcome. What is the error?

  Read the article

• Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing

  - by Paresh

  I am getting the error from the application as following with SQL server 2005 "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0" How can i find the stage where this error raised? how can i found the missing transaction or the stored procedure where it is not committ or rollback?

  Read the article

• Finding all tables and fields on "many" side of relations with a certain table

  - by bzamfir

  in Sql Server 2005, I have a master table, and several other tables which are related to this master through several one to many relations. How can I find all tables and fields which are in relation with the primary key in the master table, on "many" side? I know I can extract this by querying views from INFORMATION_SCHEMA, but I don't know where exactly I can find this info. Thank you

  Read the article

• TSQL, How to get smalldatetime's time between two smalldatetime's times ?

  - by eugeneK

  I have Table with two smalldatetime columns, where one is startTime and other one is endTime. I need to select all values from table which between times of both columns compared to getdate()' time. I'm using SQL-Server 2005. example startDate endDate value1 2/2/01 16:00 2/2/01 18:00 1 2/2/01 21:00 2/2/01 22:00 2 2/2/01 05:00 2/2/01 22:00 3 getdate() gives 2/2/2000 21:40 so i need to get value1 2 and 3 thanks in advance

  Read the article

• SQL Server: Is it possible to get procedure or table creation and last alter date?

  - by Woland

  SQL Server: is it possible to get procedure or table creation and last alter date? If it is then how do to it? SQL Server 2005

  Read the article

• How to get numeric random uniqueid in MS sql server

  - by Rajesh Rolen- DotNet Developer

  i am using sql server 2005, please tell me how can i get 6 digits (unique numeric which should be random) value for every row in table. i have a field in table in which i needs 6 digit numeric value (random and unique). please help me to do this.

  Read the article

• Forgot SQL Server Password

  - by buyutec

  I installed SQL Server 2005 sometime ago and forgot the administrator password I set during setup. How can I connect to SQL server now? EDIT: I think I only allowed Sql Server Authentication. Login with integrated security also does not work.

  Read the article

• How can I compare tables in two different databases using SQL?

  - by chama

  I'm trying to compare the schemas of two tables that exist in different databases. So far, I have this query SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('table1') The only thing is that I don't know how to use the sys.columns to reference a database other than the one that the query is connected to. I tried this SELECT * FROM db.sys.columns WHERE object_id = OBJECT_ID('table1') but it didn't find anything. I'm using SQL Server 2005 Any suggestions? thanks!

  Read the article

• sql server - select top and bottom rows

  - by Adrian Faciu

  Hi, I'm using Sql Server 2005 and i'm trying to achieve something like: In the same select statement i want to get the first x rows and the last x rows. SELECT TOP(5) BOTTOM(5) Of course 'bottom' does not exist so i need other solution. I believe there is an easy and elegant solution that i'm not getting. Doing the select again with Group By Desc is not an option. Thanks.

  Read the article

• Run sql script from console and not from query analyzer in SQL server

  - by Spyros

  Hello , i have written an sql script for updating a database that runs in SQL server 2005 and I want to make that changes to the production DB server but I dont want to run the query from the query analyzer , is there a way to run the sql script from console?

  Read the article

• how to restore a database from different computers into one

  - by habdem2003

  I have 3 computers having the same sql server 2005 database, i would like to gather the data from the 3 computers to another computer which has the same database. pls help me tnx in advance

  Read the article

< Previous Page | 50 51 52 53 54 55 56 57 58 59 60 61  | Next Page >