Search Results

Search found 29050 results on 1162 pages for 'sql agent'.

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

• SQL Server Service Broker - An Introduction

  SQL Server Service Broker (SSBS), introduced with SQL Server 2005 and enhanced in SQL Server 2008, allows you to write queuing/message based applications within the database itself. This article discusses SSBS' important features and how to use it in different scenarios.

  Read the article

• How to create a Table with fields in a Access Database (ADOX and JET SQL)

  Creating a simpleTable with fields in a Access Database using ADOX and JET SQL

  Read the article

• Set Vs Select statement in SQL Server

  Set Vs Select statement in SQL Server

  Read the article

• Remove common substring from the strings in a column in SQL Server

  Remove common substring from the strings in a column in SQL Server

  Read the article

• SQL SERVER Interview Questions

  SQL SERVER Interview Questions contains 1 General Questions of SQL SERVER...…………………… 2 Common Questions Asked……………………………………… 3 Questions of SQL SERVER 2008……………………………

  Read the article

• Inline variable assignments in SQL Server 2008

  Inline variable assignments in SQL Server 2008

  Read the article

• Find index associated with the table in SQL Server

  Find index associated with the table in SQL Server

  Read the article

• Keyboard Shortcuts in SQL Server

  Keyboard Shortcuts in SQL Server

  Read the article

• SQL Server Stored Procedures Comparer

  Windows application that compares stored procedures between two SQL Server database

  Read the article

• Basics of SQL Server 2008 Locking

  Relational databases are designed for multiple simultaneous users, and Microsoft SQL Server is no different. However, supporting multiple users requires some form of concurrency control, which in SQL Server's case means transaction isolation and locking. Read on to learn how SQL Server 2008 implements locking.

  Read the article

• Basics of SQL Server 2008 Locking

  Relational databases are designed for multiple simultaneous users, and Microsoft SQL Server is no different. However, supporting multiple users requires some form of concurrency control, which in SQL Server's case means transaction isolation and locking. Read on to learn how SQL Server 2008 implements locking.

  Read the article

• How To Check Duplicate data in sql

  In Sql Hw to check duplicacy

  Read the article

• LINQ to SQL Performance Considerations

  Performance considerations when using LINQ to SQL

  Read the article

• SQL server Interview queries

  SQL server Interview queries

  Read the article

• SQL server Interview queries

  SQL server Interview queries

  Read the article

• Importing data from spreadsheet (xls) to SQL database

  CSV 2 SQL Script Generator

  Read the article

• Error in inserting records in SQL Server

  Error in inserting records in SQL Server

  Read the article

• Enable xp_cmdshell in SQL Server

  Enable xp_cmdshell in SQL Server

  Read the article

• sp_who and sp_who2 in SQL Server

  sp_who and sp_who2 in SQL Server

  Read the article

• ????????PL/SQL ??????Tips

  - by Yusuke.Yamamoto

  ????? ??:2005/05/02 ??:?????? PL/SQL ????????????????·??????·???????????? PL/SQL ?? ?????????/ DBMS_OUTPUT?UTL_FILE?DBMS_SQL?DBMS_PIPE?DBMS_ALERT?DBMS_JOB?DBMS_UTILITY?DBMS_LOCK.SLEEP?DBMS_RANDOM?DBMS_OBFUSCATION_TOOLKIT?DBMS_CRYPTO?UTL_SMTP?UTL_MAIL ?????/?????? ?????? PL/SQL ????? PL/SQL ??????? ????????? ????????????????? http://otndnld.oracle.co.jp/tech/pl_sql/pdf/plsql_tips10g.pdf(10.1.0 ???) http://otndnld.oracle.co.jp/tech/db_connect/pdf/PLSQL_TECH.pdf(8.0.5 ???)

  Read the article

• How to build a setup package for a desktop application using SQL CE 3.5 and Entity Framework?

  - by Emad

  I am having a WPF desktop application that uses SQL CE (compact edition 3.5 ) and using the Entity Framework as a Datalayer. As It turned out in (http://support.microsoft.com/default.aspx?scid=kb;en-us;958478&sd=rss&spid=2855 ) and (http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/b6bac277-cf66-4c74-a0b3-e48abedbd161/ ) There Is some problem with the Entity Framework and SQL CE and I had to get the hotfix (basically a new build of the SQL CE called 3.5.1) My problem now is how to build a setup package in order to make it work in case some users already had the SQL CE 3.5 installed on their machines? I have included the DLLs directly in the application but when the sql ce is installed, its DLLs are in the GAC and have precedence over the local ones and the application crashes. I need the build a setup that would work "even if" the user already had the old buggy version.

  Read the article

• How to register System.DirectoryServices for use in SQL CLR User Functions?

  - by Saul Dolgin

  I am porting an old 32-bit COM component that was written in VB6 for the purpose of reading and writing to an Active Directory server. The new solution will be in C# and will use SQL CLR user functions. The assembly that I am trying to deploy to SQL Server contains a reference to System.DirectoryServices. The project does compile without any errors but I am unable to deploy the assembly to the SQL Server because of the following error: Error: Assembly 'system.directoryservices, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.' was not found in the SQL catalog. What are the correct steps for registering System.DirectoryServices on SQL Server?

  Read the article

• Linq to SQL Azure genrating Error "Specified cast is not valid."

  - by Rabbi

  B"H I have an application that has been working for months using Linq to SQL connecting to a SQLExpress. I tried migrating it to SQL Azure. I copied the structure and data using the Sync Framework. I viewed the data in SQL Azure using SSMS 2008 R2 and it seams to be exactly what I have in my Sql Server. However when I try to use Linq to SQL against it I get an error "Specified cast is not valid." I seams to be happening any time I get child records. i.e. whenever I fill (the first time I access) an entity set. It seams to be happening after the data returns and when Linq tries to put it into the objects. remember, the application is working perfectly against sqlexpress, even when accessed across the internet or vpn.

  Read the article

• Linq to SQL Azure generating Error "Specified cast is not valid."

  - by Rabbi

  B"H I have an application that has been working for months using Linq to SQL connecting to a SQLExpress. I tried migrating it to SQL Azure. I copied the structure and data using the Sync Framework. I viewed the data in SQL Azure using SSMS 2008 R2 and it seams to be exactly what I have in my Sql Server. However when I try to use Linq to SQL against it I get an error "Specified cast is not valid." I seams to be happening any time I get child records. i.e. whenever I fill (the first time I access) an entity set. It seams to be happening after the data returns and when Linq tries to put it into the objects. Remember, the application is working perfectly against sqlexpress, even when accessed across the internet or vpn.

  Read the article

• In SQL Server, can multiple inserts be replaced with a single insert that takes an XML parameter?

  - by Mayo

  So I have an existing ASP.NET solution that uses LINQ-to-SQL to insert data into SQL Server (5 tables, 110k records total). I had read in the past that XML could be passed as a parameter to SQL Server but my google searches turn up results that store the XML directly into a table. I would rather take that XML parameter and insert the nodes as records. Is this possible? How is it done (i.e. how is the XML parameter used to insert records in T-SQL, how should the XML be formatted)? Note: I'm researching other options like SQL bulk copy and I know that SSIS would be a good alternative. I want to know if this XML approach is feasible.

  Read the article

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