Search Results

Search found 89335 results on 3574 pages for 'server restart'.

Page 309/3574 | < Previous Page | 305 306 307 308 309 310 311 312 313 314 315 316  | Next Page >

• How do to massively alter primary keys to tables in sql server database

  - by shuxer

  Hi Is there any way to massively alter primary keys(uid) to all tables with no primary primary keys in sql server database ? I have a lot of tables and most of them don not have primary keys. Thanks in advance.

  Read the article

• Lib for LIMIT statement in SQL SERVER?

  - by acidzombie24

  Is there some lib or function i can use to take my basic sql statement and transform the limit statement to a sql server compatible statement?

  Read the article

• Saving russian text in SQL server

  - by JD

  Hi, I have a database (SQL server express 2008) which has a column that is defined as text. When we try to store some text which is in chinese, it is not saved. I read that the field should be ntext. I will now have to a conversion to my table to create the column as ntext. Would I have to do anything with the collation of the database which is set to Latin? JD

  Read the article

• SQL Server: how to set return format ?

  - by Quandary

  Question: The new SQL Server 2008 database returns me values formatted English (date/float). Is there a way I can set the return format ? For example temporarely switching the database language? Or just set the language for the current query ?

  Read the article

• Subversion and Windows Server 2008

  - by Frozzare

  Hello. I install the subversion on my windows server 2008. But it's only work localhost. It don't work when i try from another computer. I can't find out whats the problem is. Are there any ports or something like that i need to configure? This was the guide i follow Thaks for your help

  Read the article

• inserting only date in a column in sql server

  - by sam

  hi! Is there a way to insert only date in a datetime column in sql server without the time? for example date (datetime) =============== 12-01-2000 16-02-2000 or i should store this as a varchar and cast it when retriving so that i can convert to whatever form i need.

  Read the article

• SQL Server: Declaring variable type based on a column type

  - by Bernard Dy

  In Oracle's PL-SQL, you can declare a variable and define its type based on a table column: declare var1 table.column%TYPE; Is it possible to do something similar in MS SQL Server? I searched but could not find a duplicate for this question. If there is one, please let me know and I'll refer to it and delete this.

  Read the article

• Mercurial & Windows Server 2003

  - by tjsimmons

  Hi all, I just set up Mercurial on our main webserver, hosting repositories via hgwebdir.cgi. The problem I'm having now is when I run hg push from my local machine to the server's repository, it takes an absolutely ridiculous amount of time to push a very small directory, with only a single changeset. Is it possible that I've set something up wrong? I keep getting HTTP Error 502: Bad Gateway. Thanks!

  Read the article

• auto incrementing id in sql server

  - by Sagar

  How to auto increment an id in SQL Server whenever a new row is inserted in the table? This id is primary key of the table.

  Read the article

• How to secure an mdf file from adminstrators in SQL Server 2005 Express Edition

  - by shmandor

  I need a way to make my database mdf file secure from any adminstrators in SQL Server Express. Because I am developing application with C# connected to SQL Express database.

  Read the article

• help troubleshooting deadlocks in sql server database

  - by Makach

  I've got two database servers, (1) production (2) test on the production database I get frequent deadlocks and I'm trying to find out what is causing it. I take a backup of the database in production and restore it in test and when I perform the exact same scenario that yields deadlocks on the production server I am unable to reproduce in test. any ideas/tips/hints would be much appreciated.

  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

• sql server query/subquery question

  - by parminder

  Hi Experts, I have a tables with data like this Id BookId TagId 34 113421 9 35 113421 10 36 113421 11 37 113421 1 38 113422 9 39 113422 1 40 113422 12 I need to write a query (SQL Server) which gives me data according to the tags say if I want bookIds where tagid =9 it should return bookid 113421 and 113422 as it exists in both the books, but If I ask data for tags 9 and 10 it should return only book 113421 as that is the only book where both the tags are present. Thanks Parminder

  Read the article

• Tools to update tables in SQL server 2000/2005

  - by Stan

  Is there any handy tool that can make updating tables easier? Usually I got an Excel file with the original value in one column and new value in another column. Then I write a formula in Excel to create the 'update' statement. Is there any way to simplify the updating task? I believe the approach in SQL server 2000 and 2005 would be different, so could we discuss them both? Thanks.

  Read the article

• SQL Server and Identity column

  - by andrew007

  Hi, I just noticed that if I have an identity column in a table, when I insert new rows SQL Server 2008 is automatically filling up the sequence if there are discontinuity. I mean, if in my identity column I have 1,2,5,6 if I insert other two rows in the table the system puts automatically 3,7 in the identity column. Do you know how to control this behavior? THANKS

  Read the article

• MS SQL SERVER BACKUP Issue

  - by Dhivagar

  In sql server 2008, i have taken Full backup type of my database and database was successfully done.My question is while restoring it how can i check or know that my whole backup was perfect ?

  Read the article

• File size in Python server

  - by Anna

  We have server on Python and client + web service on Ruby. That works only if file from URL is less than 800 k. It seems like "socket.puts data" in a client works, but "output = socket.gets" - not. I think problem is in a Python part. For big files tests run "Connection reset by peer". Is it buffer size variable by default somewhere in a Python?

  Read the article

• Sql Server xml column with Entity Framework - how to keep insignificant whitespaces

  - by Saravanan

  Sql server 2005 (even 2008) strips the insignificant whitespaces by default. To keep one can use the CONVERT funtction with the last argument as '1' (Ref. Article). How can we do the same thing in Entity Framework? thanks

  Read the article

• Sql server backup with password

  - by Skun

  Hello, world. When we backup data in SQL server, i want a way to password protect it. Is there a way to do this without using third party tools ?

  Read the article

• MS Sql Server Object Creation / Alter Script

  - by Chris Klepeis

  Hi, In Sql Server when you select to modify a SP or UDF it loads the objects alter query in a query window. Are these queries accessible in a system table so I can store the alter statements somewhere? It looks like syscomments has some objects but not all of them. Thanks

  Read the article

• Windows server issue with a product

  - by peter

  Can you tell me the meaning of this statement.I am using windows 2008 server OS Log Problem must be changed so that it elevates privileges for a user executing the Problem. its done by creating a manifest that indicates that Problem needs Administrator privileges.

  Read the article

• SQL Server 2008 management studio drop tables warning?

  - by Curtis White

  Why does SQL server 2008 always warn about needing to drop tables to rename columns? I was under impression this was not required unless it was a key. If I change a column from null to not null even if is not a key field it wants to drop table and all relations.

  Read the article

• Migrate MySQL database to Sql Server

  - by RPK

  I recently encountered a problem in my production database due to MySQL bug. The bug is in the TimeStamp column. To avoid any inconvenience, I want to migrate the database to either Sql Server. Is there any FREE tool to easily and reliably migrate data and table structures?

  Read the article

• Ever increasing number of rows returned for SQL Server database

  - by Maestro1024

  I have a SQL Server Express database that has a query that should return about 230 thousand rows. Problem is the query returns about 5 more rows each time you run the query. What would cause something like this? I ran 'DBCC CHECKDB' but that did not change the behavior. Any ideas. thanks

  Read the article

• Limiting the number of queries returns in SQL Server 2008

  - by Jose Sotero Villegas III

  This is my query SELECT Fullname, rank, id_no, TIN, birthdate, hair, eyes, Blood, height, weight, marks, name, address FROM [******_DOMAIN\****_*****].*******view Problem is, source table has too many duplicates, how do I my limit query to the latest row on the database? I'm using SQL Server 2008. Thanks In advance My next problem is that the view shows me a birthdate string format of yyyymmdd, I need to change it to mm/dd/yyyy can please provide me a function? using the same string above?

  Read the article

< Previous Page | 305 306 307 308 309 310 311 312 313 314 315 316  | Next Page >