Search Results

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

Page 553/3731 | < Previous Page | 549 550 551 552 553 554 555 556 557 558 559 560  | Next Page >

• List of SQL Server errors that should be retried?

  - by Christopher

  Is there a concise list of SQL Server stored procedure errors that make sense to automatically retry? Obviously, retrying a "login failed" error doesn't make sense, but retrying "timeout" does. I'm thinking it might be easier to specify which errors to retry than to specify which errors not to retry. So, besides "timeout" errors, what other errors would be good candidates for automatic retrying? Thanks!

  Read the article

• Does SQL Server have any kind of magic undo feature?

  - by Andrew G. Johnson

  Long story short is I tried to quickly update a single row in SQL Server using the Management studio and just typed UPDATE table SET column='value' and forgot the WHERE other_column='other_value' portion. Went for lunch, came back and theres 15 unread emails waiting for me. Happened about an hour ago, waiting for the database guy to come back to see when the last backup was. There's no magic UNDO feature though is there?

  Read the article

• How can I get all the database names in a sql server instance using tsql?

  - by Yousui

  Hi guys, How can I get all the database names in a sql server instance using tsql? Great thanks.

  Read the article

• Does Visual Studio 2010 Beta 2 Include a TFS server?

  - by Russell

  I recently downloaded Visual Studio 2010 beta 2, and was told it included a TFS server. However I am unsure of if it has/can be installed, or how to start it up if it has been. Can anyone shed any light on this for me please? Thanks :) Thanks for your help :) I am downloading the ISO of the separate product instead from msdn.

  Read the article

• Why is fulltextsearch for phrase ignored in SQL Server?

  - by cpt.oneeye

  I am executing the following SQL statement on an indexed SQL Server 2008 R2 database. SELECT * FROM mydatabase WHERE (CONTAINS(ColumnA,'"The Apple is red"')) The problem is that it returns too many entries. It also returns entries where 'ColumnA' contains only one of the words ('Apple' or 'is' or 'red'...) and not only the entries which contains the exact phrase. According to MSDN this should be the way to search for a phrase. Thanks cpt.oneeye

  Read the article

• how to determine date when service pack was applied to SQL Server instance?

  - by Oliver

  For an instance of SQL Server 2005/2008, how can one determine the date and time when a service pack was applied to the instance? Is there a system table or view that stores that information?

  Read the article

• In SQL Server, how to quickly get a general idea of an instance?

  - by Yousui

  Hi guys, If you are a new sql server dba and you just get an account of an instance. What would you do to know the instance and databases? How to quick get a general idea of this instance and databases? Great thanks.

  Read the article

• what the IIS featuer need to install or change in pc have windows 7 home to work sql server 2005 ss

  - by bassam

  what the IIS featuer need to install in pc have windows 7 home to work sql server 2005 (32 bit) ssrs not work i change all windows featuer in the PC what i need to install in pc

  Read the article

• How to Create Adobe AIR MJPEG server? (AIR 2.0)

  - by Ole Jak

  So all I want to stream images from my WebCam onto some local adress\port and be able to see them as MJPEG stream. I want server (one that shares MJPEGS) and CLIENT (That sends MJPEGS) be in the same air app. Can you give me link to working opensource project DETAILED STEP BY STEP instructions on what should I do\implement and where to find code examples

  Read the article

• Is the max limit of 4 GB on sql server 2005 express .mdf + .ldf or for .mdf only ?

  - by HotTester

  Is the max limit of 4 GB on sql server 2005 express .mdf + .ldf or for .mdf only ? Kindly clarify. Thanks.

  Read the article

• How to install Visual Studio 2008 and MS SQL Server 2008 in Ubuntu ?

  - by Vicheanak

  Hi guys, I would like to install Visual Studio 2008 and MS SQL Server 2008 on Ubuntu OS which I have in my PC, however, I don't know how. May I have some tips please? Thanks.

  Read the article

• how to format a date in sql server 2008.

  - by Shantanu Gupta

  How to format a date in sql sevrer with format dd-mm-yyyy to some other format without using convert function. Is it there any such function in sql server 2008 or 2005

  Read the article

• What is the best method for Migrating or Restoring Project Server (PWA) to a new environment for tes

  - by JustinB

  I have attempted bringing up a new farm and performing a stsadm backup/restore with no success. I have also tried doing a stsadm export/import with similar results. I need to migrate/copy PWA to another server for testing purposes and I am at a standstill. What is the best method to accomplish this?

  Read the article

• How do I capture the Application.Exit event in the Home Server Console?

  - by Magnus Johansson

  I have a WHS Addin, and I now want to do some cleanup whenever the Windows Home Server Console is closed. I have tried the Application.ApplicationExit event, but it seems it doesn't get fired. Any ideas?

  Read the article

• Where does sql server stores the stored proecdure code?

  - by NoProblemBabe

  I once needed the lines of the stored procedures, to be able to trace whether i have a reference to some function, procedure or table, or sometimes to try to find something inside of the sp's code. Where does the sql server stores the procedures's code?

  Read the article

• Why does SQL Server 2008 suggest I have the primary key column as an included column in an index

  - by Raine

  SQL Server 2008 is telling me to include the Primary Key in an index in the Included Column field. I thought the PK was automagically returned with all indexes?

  Read the article

• How can I connect to a mysql db from a different server ?

  - by HJ-INCPP

  Hello, I have, let's say, a root website with mysql db on a remote server. I want to connect to that particular database (to make queries), from many other little websites (with lower priviledges). Can this be done? Language: jsp,java,php Thank you

  Read the article

• When deploying python, what web server options do we have? is the process inefficient at all?

  - by Blankman

  I think in the past python scripts would run off CGI, which would create a new thread for each process. I am a newbie so I'm not really sure, what options do we have? Is the web server pipeline that python works under any more/less effecient than say php?

  Read the article

• Hyper-V snapshot backup strategy appropriate for production SQL server?

  - by Chuck

  So SQL Server 2008 in Hyper-V is a supported configuration, and should perform well as long as you use fixed or pass-through disks and increase your processor/memory settings appropriately. My question is can I use snapshots as a reliable backup mechanism, or should I use the tried and trusted maintenance plan to do my backups?

  Read the article

• how to show only even or odd rows in sql server 2008 ?

  - by Gold

  hi i have a table MEN in sql server 2008 that contain 150 rows. how i can show only the even or only the odd rows ? thank's in advance

  Read the article

• In SQL Server, how do I know what transaction mode I'm currently using?

  - by Yousui

  Hi guys, In SQL Server, how do I know what transaction mode I'm currently using? Such as autocommit, explicit, or implicit. And how can I change one mode to another using tsql? Great thanks.

  Read the article

• How to execute big SQL files on SQL Server?

  - by Alon

  I have about 50 T-SQL files, some of them are 30MB but some of them are 700MB. I thought on executing them manually, but if the file is bigger than 10MB it throws an out of memory exception on the SQL Server Management Studio. Any ideas?

  Read the article

• How do I add a record only if it doesn't already exist in SQL Server?

  - by menacheb

  Hi, I have a project in C# with a Sql-server Database. In that database I have a table named 'Process' and columns named 'process_name', 'Full_Name' and 'Version' (all of the type:nvarchar(50)). I want to write a query wich will add the new process, only if it doesn't exist in the table yet. How can I do that? Many thanks,

  Read the article

• SQL SERVER Query result in CSV format is possible?

  - by gopal

  Hi, Is it possible to get the query result in .CSV file format from SQL SERVER 2000 and above versions? If so can we use this feature from an asp.net application to get the result in CSV format? If so how can we do this?

  Read the article

• Looking for a tool that can return SPs doing a DML on a table in SQL Server 2008

  - by Kiran

  I am working on a big application on SQL Server 2008 with 60 000 stored procedures and over 10 000 tables. Is there a tool through which I can do impact analysis to find out all SPs doing a DML on a table?

  Read the article

< Previous Page | 549 550 551 552 553 554 555 556 557 558 559 560  | Next Page >