Search Results

Search found 93271 results on 3731 pages for 'server manager'.

Page 330/3731 | < Previous Page | 326 327 328 329 330 331 332 333 334 335 336 337  | Next Page >

• 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

• vb.net : is it possible to connect to sql server 2008 via odbc but not through vb.net code?

  - by phill

  I'm supporting an old vb.net program whose database it connected to was moved from SQL Server 2005 to SQL Server 2008. Is there a setting on SQL Server 2008 which will allow ODBC connections to access the database but not allow VB.NET to connect to it programmatically? the error i keep receiving in the app is: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) however I can connect to it when I create a system dsn to the sql server instance and through VS2005's Tools Connect to Database. Here is the code I'm using to connect: dim strC as string strC = "data source=bob; database=subscribers; user id=bobuser; password=passme" dim connection as New SqlClient.SqlConnection(strC) try connection.open() catch ex as Exception msgbox(ex.message) end try connection.Close()

  Read the article

• What is new for developers in SQL Server 2008 R2

  - by Eduardo Molteni

  Today was released SQL Server 2008 R2. Was trying to find what is new (from the developer perspective), but the MS sites has all the PR blah, blah, blah. There is something new to be aware?

  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

• 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

• 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

• 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 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

• 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

• 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

• 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

• 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

• Update thousands of records in a DataSet to SQL Server

  - by MSIL

  I have half a million records in a data set of which 50,000 are updated. Now I need to commit the updated records back to the SQL Server 2005 Database. What is the best and efficient way to do this considering the fact that such updates could be frequent (though concurrency is not an issue but performance is)

  Read the article

• SQL Server 2005 Partition Over Date Range

  - by zimdanen

  Is there a way in SQL Server to parition over a date range? I'm looking for something along these lines: SELECT ROW_NUMBER() OVER (PARTITION BY RANGE(DateTimeField) INTERVAL(1)) I want to group rows that are within one day of each other.

  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: 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

• 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

• 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

• 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 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

• 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

• 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

• 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

• 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

• java jsp : connecting to sql server tutorial?

  - by phill

  Can anyone recommend a tutorial on how to write a java servlet which connects to ms sql server and manages data? I'm trying to write something which pulls products out of one database and inserts them into a stored procedure located on another database. thanks in advance

  Read the article

< Previous Page | 326 327 328 329 330 331 332 333 334 335 336 337  | Next Page >