Search Results

Search found 93962 results on 3759 pages for 'server configuration'.

Page 216/3759 | < Previous Page | 212 213 214 215 216 217 218 219 220 221 222 223  | Next Page >

• what is the difference between INSTEAD OF and AFTER trigger in SQL Server?

  - by Venkat

  What is the difference between INSTEAD OF and AFTER trigger in SQL Server? INSTEAD OF trigger invoked before unique key constraint, will the AFTER trigger invoke after unique key constraint?

  Read the article

• Is there any way to view whitespace in the query editor for SQL Server Management Studio Express 200

  - by Pandincus

  I have it enabled in Visual Studio 2008, but I'd really like to enable this feature in SQL Server Management Studio 2005 Express. Does anyone know if its possible? Maybe in a later version? EDIT: Sorry, I meant specifically in the text/query editor.

  Read the article

• What is the Auto-Close option when creating a new database in SQL Server 2008?

  - by brian

  What is the Auto-Close option when creating a new database in SQL Server 2008? EDIT: and how do you decide whether to turn it on or off?

  Read the article

• Is there any way to view whitespace in SQL Server Management Studio Express 2005?

  - by Pandincus

  I have it enabled in Visual Studio 2008, but I'd really like to enable this feature in SQL Server Management Studio 2005 Express. Does anyone know if its possible? Maybe in a later version?

  Read the article

• How to organize infinite while loop in SQL Server ?

  - by alpav

  I want to use infinite WHILE loop in SQL Server 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

• How do I do batch upserts in SQL Server?

  - by Dmitri Nesteruk

  I'm using the MERGE statement to upsert rows in an sql server 2008 database. However, my sproc is a single-row operation, whereas in fact I'd prefer to batch these. Is this even possible and, if so, how do I do it?

  Read the article

• Store a byte[] stored in a SQL XML parameter to a varbinary(MAX) field in SQL Server 2005. Can it be

  - by Mikey John

  Store a byte[] stored in a SQL XML parameter to a varbinary(MAX) field in SQL Server 2005. Can it be done ? Here's my stored procedure: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[AddPerson] @Data AS XML AS INSERT INTO Persons (name,image_binary) SELECT rowWals.value('./@Name', 'varchar(64)') AS [Name], rowWals.value('./@ImageBinary', 'varbinary(MAX)') AS [ImageBinary] FROM @Data.nodes ('/Data/Names') as b(rowVals) SELECT SCOPE_IDENTITY() AS Id In my schema Name is of type String and ImageBinary is o type byte[].

  Read the article

• How can I change the look of SQL Server Managment Studio based on which database I'm connected to?

  - by Traples

  I'd like to modify the appearance of the query window in SQL Server Management Studio based on which database I'm currently connected to. For example, using a yellow background for production databases. Is there a way to do this?

  Read the article

• How do I find out the expiry date of a SQL Server 2008 trial-install instance?

  - by Peter Mounce

  So I installed a trial of SQL Server 2008 enterprise edition while waiting for MSDN licenses to come through - I now want to uninstall the trial and replace it with a developer edition installation. However, I'd like to first know how long I have left on the trial. Is there a way to do this programmatically with SQL? I looked at create_date in sys.databases, but these give dates that are in 2003 (which is, I guess, when master and model were originally created).

  Read the article

• T-SQL: How to know how much storage space is left in sql server express?

  - by user193655

  How is it possible to know how much of the "DB quota" imposed by SQL Server express edition (4GB in old versions, 10GB in 2008R2) is in use? Let's say I have a DB that is using 1GB, I want to know "9GB of free space". Is it there a T-SQL command for this?

  Read the article

• Is there any function in SQL Server to convert a number into Time format?

  - by Shashi Bhushan

  I am getting a whole number for the duration of product. For example : 62, 103, 184, 4543. I want to convert it in time format. Let say , in case of 62, it would format like '00:01:02'. I am looking for a function which can resolve my problem. Is there any function in SQL Server which convert a number into time format?

  Read the article

• How many maximum recursion possible for CTE in SQL server?

  - by Paresh

  How many maximum recursion level possible for CTE in SQL server? If maximum recursion level is reached then what are the alternative way?

  Read the article

• What kind of encryption mechanisms does MS SQL Server 2008 Standard offer?

  - by Przemyslaw Rózycki

  As I see, TDE and EKM mechanisms are available only in Enterprise edition. How can I encrypt data in tables in Standard edition of SQL Server 2008?

  Read the article

• How can I determine installed SQL Server instances and their versions?

  - by Luke

  I'm trying to determine what instances of sql server/sql express I have installed (either manually or programmatically) but all of the examples are telling me to run a SQL query to determine this which assumes I'm already connected to a particular instance.

  Read the article

• How to find the worst performing queries in MS SQL Server 2008?

  - by Thomas Bratt

  How to find the worst performing queries in MS SQL Server 2008? I found the following example but it does not seem to work: SELECT TOP 5 obj.name, max_logical_reads, max_elapsed_time FROM sys.dm_exec_query_stats a CROSS APPLY sys.dm_exec_sql_text(sql_handle) hnd INNER JOIN sys.sysobjects obj on hnd.objectid = obj.id ORDER BY max_logical_reads DESC Taken from: http://www.sqlservercurry.com/2010/03/top-5-costly-stored-procedures-in-sql.html

  Read the article

• how Do I list all table names in SQL Server using T-SQL?

  - by shrimpy

  SELECT name FROM sys.databases -- this can list all database name in the server user database SELECT * FROM INFORMATION_SCHEMA.TABLES -- these two line can list the table for one particular database But how can I output the results like below? Database Table --------- ------------- db1 t1 db1 t2 db2 t1 ... ...

  Read the article

• Is there any available free & open source implementation of RSA-2048 for SQL Server 2000?

  - by Victor Rodrigues

  I'm trying to do some cryptography for SQL Server 2000, and I know that only SQL 2005+ comes with built-in functionality for doing this natively. Do you know any open source implementation that I can use for free of RSA-2048 cryptography?

  Read the article

• How to Add a default value in SQL server compact?

  - by Suryakavitha

  Hi , I need to add default value column in SqlServer Compact....i am new to this SQL server compact so Plz anyone tell me the Solution of this.... Thanks In Advance

  Read the article

• Cam you insert the results of a dynamic sql call into a SQL Server 2005 table variable

  - by codingguy3000

  Is there anyway to do this in SQL Server 2005? declare @tv_tablelist table (recnum int identity(1,1) primary key, newvar varchar(500)) declare @mysql nvarchar(4000) set @mysql = 'insert into @tv_tablelist(newvar) values (''test test test'')' Exec sp_executesql @mysql, N'@tv_tablelist table (recnum int identity(1,1) primary key, newvar varchar(500)) OUTPUT', @tv_tablelist OUTPUT select * from @tv_tablelist

  Read the article

• How to ignore noiseXXX.txt files for a specific column in SQL Server 2005?

  - by John MacIntyre

  I have a product table where the description column is fulltext indexed. The problem is, users frequently search a single word, which happens to be in the noiseXXX.txt files. We'd like to keep the noise word functionality enabled, but is there anyway to turn it off just for this one column? I think you can do this in 2008 with the SET STOPLIST=OFF, but I can't seem to find similar functionality in SQL Server 2005.

  Read the article

• SQL Server 2005 Merge Replication: Under what circumstances would the base snapshot expire?

  - by Gareth

  Obviously changing schema, adding / removing published articles etc expires the snapshot, but is there anything else that would cause the publication to expire? We're seeing a snapshot expiring without any changes to schema or data on the server. If a snapshot is older than the subscription expiration, would that cause it to be expired?

  Read the article

• In SQL Server, how can I insert data into a table that has just one column which is of identity type

  - by Yousui

  In SQL Server, how can I insert data into a table that has just one column which is of identity type? Such as insert into the following table t. How can I write the insert statement? CREATE TABLE t ( id INT IDENTITY(1, 1) PRIMARY KEY ) Great thanks.

  Read the article

• Does the port change when a TCP connection is accepted by a server?

  - by zooropa

  When a client connects to a server using TCP, a new socket is created for the TCP stream. Does the connection remain on the same port the connection was made or does it get changed to some other port?

  Read the article

• How to make a table Read Only in SQL Server?

  - by Jeyavel

  Hi, i am updating some set of records in that table , after that i need to make this table read only. So How to make a table Read Only in SQL Server? Regards, Jeyavel N

  Read the article

• XML in SQL Server 2005? Better than JSON in Varchar?

  - by Henry

  What are the benefits of storing XML in SQL Server over storing JSON in a varchar field? Any tutorial available for how to use the XML data type effectively? Do I need to provide the dtd / xml schema somehow? I've heard it is optional, right? Thank you.

  Read the article

< Previous Page | 212 213 214 215 216 217 218 219 220 221 222 223  | Next Page >