Search Results

Search found 106740 results on 4270 pages for 'sql server 2005 server 20'.

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

• output window to file (visual studio 2005)

  - by Arik

  in visual studio 2005 how can i save whats written to the out put window to file (i cant change the code writing to the output window and it writes a lot i just want to save the output window content to file) thank you Arik

  Read the article

• How to create a table type in Sql Server 2005

  - by Nikola Stjelja

  Hi, I'm trying to create a table type in sql server 2005. Here is what my code looks like: CREATE TYPE NameResourceType AS TABLE ( ID int, [Value] Varchar(256) ) GO I receive the following error: Incorrect syntax near the keyword 'AS'.

  Read the article

• sql server: import operation won't copy full schema

  - by P a u l

  I recall that the import tool in sql server 2000 would copy indexes, relationships, etc. In sql server 2005/2008 the import tool in SSMS will only create the tables, copy the data, but the keys, indexes, relationships are missing. I can find no option in the import wizard to enable this? What am I missing here? Is this not possible anymore for any good reason?

  Read the article

• SQL Server 2005 Performance Dashboard Missing Index

  - by n8wrl

  I am using the performance dashboard with our SQL Server 2005 databases and it lists what it considers to be missing indexes. But some of those indexes DO exist! They are not disabled, and they are defined exactly as the dashboard says they should be. Why are they reported as missing?

  Read the article

• How to use CREATE LOGIN sql statement?

  - by truthseeker

  Hi, How to use CREATE LOGIN statement on SQL Server 2005? I was trying nearly everything, with commas, without them, with strings, without them etc. CREATE LOGIN @loginame WITH PASSWORD = 'pass', DEFAULT_DATABASE='dbname' DEFAULT_LANGUAGE='us_english', CHECK_POLICY= OFF; I always get below error: Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.

  Read the article

• problem with VS 2005

  - by persistence911

  I have a program I converted from vs 2003 to vs 2005 . It has worked fine so far until I changed one of the Dlls. Funny enough I had just One error . Maximum Number of errrors Exceeded and No other indication of other Error. Please I have been trying to fix these for like 2 days now.

  Read the article

• creating a ASP webservice project in Visual Studio 2005, Getting Error

  - by kalyaniRavi

  Hi, I am very new to .net applications. I have to create a sample ASP Webserice application in Visual Studio 2005 version, i am getting error: " 'system.Data.dll' was not found on the reference search path ". Please any one help me on this. Thanks, Ravi

  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

• VS 2005 Class Diagram View format

  - by Jebli

  Hi, I have generated class diagram by gight clicking and selecting generate class diagram usign VS 2005. There are nearly 300 class in my project . The class diagram that i have created is not in expanded view. I have to manually expand the class diagrams to view the members. Is there any way to expand the classdiagrams that are created . Regards, Jebli.

  Read the article

• Aligning Form in Visual Studio 2005

  - by patrick

  I am trying to add functionality to a form in Visual Studio 2005 that extends the form to the left. However, I am unable to figure out how to change the top and left alignment of he form in the form designer. There has to be a way to change the alignment of a form in the designer, right?

  Read the article

• Visual Studio 2005 Error

  - by xscape

  Im currently debugging a webservice written in visual studio 2005, however when i build it, it has an error but it did not specify anything Error 1 The specified module could not be found. (Exception from HRESULT: 0x8007007E) error message can be seen here Badly needed your help. Thank you

  Read the article

• How to Reset a Working folder VSS 2005

  - by Adam Tegen

  In Visual Source Safe 6.0, you could "reset" a working folder by setting it to a blank string. This meant that the working folder would be determined by the working folder of the parent. How do I do this in Visual Source Safe 2005?

  Read the article

• How to use split in SQL Server 2005?

  - by meenakshi

  Table column has values with comma separated for ex: (1,2,3) How to split this like 1 2 3 or 1 2 3 in SQL Server 2005.

  Read the article

• copy a table with data to another db in sql server 2005 express

  - by Luca Romagnoli

  hi, i've a db with a table. i want copy it with the data in another db. How can i do it in sql server 2005 express? thanks

  Read the article

• Can I use PowerShell with SQL Server 2005?

  - by Yousui

  Hi guys, I know SQL Server 2008 has exposed some features to PowerShell as snapins. Now I want to know whether I can use PowerShell with SQL Server 2005? I guess the answer is NO, right? Thanks.

  Read the article

• Ordering sql query results

  - by user343409

  My sql query gives the columns: product_id (which is an integer) pnl (which is float - can be negative) I get more than 100 rows. I want to filter out the top 40 rows based on abs(pnl). But the results should be ordered by pnl column only and not by abs(pnl). I want to do this for MSSQL 2005. Is there a way to do this?

  Read the article

• Eclipse Debug Mode disrupting MSSQL Server 2005 Stored Procedure access

  - by Sathish

  We have a strange problem in our team. When a developer is using Eclipse in Debug mode, MS SQL Server 2005 blocks other developers from accessing a stored procedure. Debug session typically involves opening Hibernate session to persist an entity which could be accessing a stored procedure used for Primary key generation. Debugging is done in business logic code and rarely in JDBC stored procedure call. Is there any way to configure MS SQL server or the stored procedure so that other developers are not blocked?

  Read the article

• How to insert time in SQl Derver 2005?

  - by sam

  i am creating windows application .In this i have to subtract two dates .i subtract it successfully ,i used TimeSpan to get subtracted value.But when i insert it in SQl Server 2005 db, it inserted with starting date i.e. 1/1/1900 and the calculated difference which format should i use to insert Time only? Thanks in advance

  Read the article

• Managing trace files on Sql Server 2005

  - by Sophtware

  I need to manage the trace files for a database on Sql Server 2005 Express Edition. The C2 audit logging is turned on for the database, and the files that it's creating are eating up a lot of space. Can this be done from within Sql Server, or do I need to write a service to monitor these files and take the appropriate actions? I found the [master].[sys].[trace] table with the trace file properties. Does anyone know the meaning of the fields in this table?

  Read the article

• C# Sql Server 2005 Bulk XML Delete?

  - by Goober

  I know you can do bulk XML inserts into SQL Server 2005 tables from your C# code using datasets/datatables. Is it possible to do the same but as a delete?

  Read the article

• How to reverse a string(SQL SERVER 2005, SET BASED)

  - by Newbie

  E.g. Declare @str varchar2(20) Set @str = 'A Student' Select Reverse(@str) Output: tnedutS A Expected being: Student A The output(using Reverse) is as expected. But my requirement is the one described. Help needed with SET BASED. I am using SQL SERVER 2005

  Read the article

• How to reverse a string (SQL Server 2005, SET BASED)

  - by Newbie

  E.g. Declare @str varchar2(20) Set @str = 'A Student' Select Reverse(@str) Output: tnedutS A Expected being: Student A The output(using Reverse) is as expected. But my requirement is the one described. Help needed with SET BASED. I am using SQL Server 2005

  Read the article

• Date difference in SQL Server 2005

  - by naveen

  Hi, I have two dates of the form Start Date: 2007-03-24, End Date: 2009-06-26 Now I need to find the difference between these two in the below form: 2 years, 3 months and 2 days Can someone please … in SQL Server 2005

  Read the article

• Project Euler 20: (Iron)Python

  - by Ben Griswold

  In my attempt to learn (Iron)Python out in the open, here’s my solution for Project Euler Problem 20.  As always, any feedback is welcome. # Euler 20 # http://projecteuler.net/index.php?section=problems&id=20 # n! means n x (n - 1) x ... x 3 x 2 x 1 # Find the sum of digits in 100! import time start = time.time() def factorial(n): if n == 0: return 1 else: return n * factorial(n-1) print sum([int(i) for i in str(factorial(100))]) print "Elapsed Time:", (time.time() - start) * 1000, "millisecs" a=raw_input('Press return to continue')

  Read the article

• SQL Server Central Webinar Series #20: Using SQL Storage Compress in the Real World

  Join us on July 10 at 4:00pm GMT/11:00am EDT for an in-depth look at SQL Storage Compress and learn how you can shrink the storage needs for your databases. What are your servers really trying to tell you? Find out with new SQL Monitor 3.0, an easy-to-use tool built for no-nonsense database professionals.For effortless insights into SQL Server, download a free trial today.

  Read the article

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