Search Results

Search found 30085 results on 1204 pages for 'sql trace'.

Page 77/1204 | < Previous Page | 73 74 75 76 77 78 79 80 81 82 83 84  | Next Page >

• Creating a secure SQL server login - CHECK_EXPIRATION & CHECK_POLICY

  - by cabhilash

  In SQL Server you can create users using T-SQL or using the options provided by SQL Server Management Studio.   CREATE LOGIN sql_user WITH PASSWORD ='sql_user_password' MUST_CHANGE, DEFAULT_DATABASE = defDB, CHECK_EXPIRATION = ON, CHECK_POLICY = ONAs mentioned in the previous article…

  Read the article

• Retrieving data using stored procedures with LINQ to SQL in an ASP.Net application

  - by nikolaosk

  In this post I would like to present a step by step example on how to use stored procedures with LINQ to SQL. Many people will wonder why I am bothering talking about LINQ to SQL so much. First of all I give a lot of seminars where people want to learn LINQ to SQL.A lot of people like and…

  Read the article

• Using Custom Validation with LINQ to SQL in an ASP.Net application

  - by nikolaosk

  A friend of mine is working in an ASP.Net application and using SQL Server as the backend. He also uses LINQ to SQL as his data access layer technology. I know that Entity framework is Microsoft's main data access technology. All the money and resources are available for the evolution of…

  Read the article

• SQL SERVER DATE and TIME in SQL Server 2008

  I was thinking about DATE and TIME datatypes in SQL Server 2008. I earlier wrote about the about best practices of the same. Recently I had written one of the script written for SQL Server 2008 had to run on SQL Server 2005 (don’t ask me why!), I had to convert the DATE and TIME…

  Read the article

• SQL Server Concepts and Best Practices to Build Transact SQL Stored Procedures

  Explains basic SQL Server concepts and some best practices to build Transact SQL Stored Procedures.

  Read the article

• 48hrs in Cambridge.

  - by Fatherjack

  In just over 2 weeks something pretty big in the SQL Server Community in the UK is taking place. We are going to witness the first SQL Saturday on these shores. The event is running in Cambridge, the home of the SQL Cambs user group and the chapter leader there (Mark Broadbent)…

  Read the article

• Idera Announces SQL Compliance Manager 3.6

  Perhaps the main highlight of SQL compliance manager 3.6's impressive set of features is its ability to actively track any activities of privileged users. When users of high administrative privileges access column groups in monitored tables, SQL compliance manager 3.6 issues…

  Read the article

• SQLAuthority News Whitepaper SQL Azure vs. SQL Server

  SQL Server and SQL Azure are two Microsoft Products which goes almost together. There are plenty of misconceptions about SQL Azure. I have seen enough developers not planning for SQL Azure because they are not sure what exactly they are getting into. Some are confused…

  Read the article

• MS SQL Sever 2012 Launch, New Idera Release

  Idera, a Microsoft Managed Partner and Houston-based provider of tools that specialize in the management and administration of Microsoft SQL Server, PowerShell, and SharePoint, recently announced the release of Idera SQL safe 7.0. The latest version of the SQL Server…

  Read the article

• SQL Server 2008 SP3 and HP Database Enterprise Appliance

  The list of updated features begins with an overall improved upgrading experience from SQL Server's older versions to the latest SQL Server 2008 SP3 edition. Microsoft has implemented measures that provide enhanced performance and reliability while making the upgrade…

  Read the article

• A Better Way To Extract Date From DateTime Columns [SQL Server]

  - by Gopinath

  Quite a long ago I wrote about a SQL Server programming tip on how to extract date part from a DATETIME column. The post discusses about using of T SQL function convert() to get date part. One of the readers of the post, tipped me about a better way of extracting date…

  Read the article

• Autoconf/Automake "configure.ac:2: option `-Wall' not recognized"

  - by Atmocreations

  Hello I'm trying to start with autoconf / automake for a new project. To get started, I'm reading "Using GNU Autotools" and trying to build the Hello-World-Tutorial. The required files from page 96 (real Page=105 because it's a LaTeX-Presentation) configure.ac,…

  Read the article

• SQL Server 2008 R2 Enterprise won't install on Windows 2008 R2 Enterprise

  - by Carlos Paulino

  I've been trying to install SQL Server on a new Windows Server 2008. I have tried everything but I haven't been able to narrow down the problem. When the installation fails I get " Exit code (Decimal): -2068643839". The problem with this is that according to…

  Read the article

• SQL Saturday 27 (Portland, Oregon)

  - by BuckWoody

  I’m sitting in the Seattle airport, waiting for my flight to Silicon Valley California for the SQL Server 2008 R2 Launch Event. By some quirk of nature, they are asking me to Emcee the event – but that’s another post entirely.   I’m reflecting on the SQL…

  Read the article

• SQL Saturday 27 (Portland, Oregon)

  - by BuckWoody

  I’m sitting in the Seattle airport, waiting for my flight to Silicon Valley California for the SQL Server 2008 R2 Launch Event. By some quirk of nature, they are asking me to Emcee the event – but that’s another post entirely.   I’m reflecting on the SQL…

  Read the article

• Can't view database on SQL Server 2008 with domain user

  - by abatishchev

  I created a login for a domain user (domain admin) and added it to role serveradmin, but after logging in I still can't list databases getting next error: The database MyDB is not accessible. (ObjectExplorer) Program Location: at…

  Read the article

• SQL Server 2008 Express + Reporting Services on Windows 7

  - by TimothyP

  I'm trying to install SQL Server Express 2008 and Reporting Services on a x64 Windows 7 Machine for development purposes. I've installed SQL Server 2008 Express with the Microsoft Web Platform Installer I had to manually enable the SQL Server…

  Read the article

• Setting up SQL Server 2005 to use all available memory in 32bit Windows Server 2003 - and verifying

  - by Rizwan Kassim

  There are a number of questions along this line - but they either sometimes contradict each other, or don't show how to properly verify that everything is actually working - hopefully this can be comprehensive... I'm running SQL Server 2005…

  Read the article

• SQL Server backup

  - by zzz777

  I have Full-Backup-A Transaction-Log-Backup-A Transaction-Log-Backup-B (*) - I have to restore this point Full-Backup-B How to do it? It seems that the only way is Full-Backup-A Transaction-Log-Backup-A Transaction-Log-Backup-B…

  Read the article

• MS SQL Server and "No Hard Drive Space Left"

  - by bobber205

  Got a server running a document delivery system on it. The machine is running extremely poorly (Windows XP). I've checked the regular things, like doing a memtest (turned out fine) and trying to degraf the HDD (not needed). The only…

  Read the article

• SQL Server: "This filegroup cannot be used as a backup destination" error when attempting restore

  - by Ariel

  When running a command like the following: "RESTORE FILELISTONLY FROM DISK='\\\\server\\folder\\DummyDB.bak'" I'm getting this error: Backup destination "\\server" supports a FILESTREAM filegroup. This filegroup cannot be used as…

  Read the article

• Generate SQL Scripts from MSSQL 2005 (Including Data)

  - by Pino

  Title says it all really, whats the quickest way to do this?

  Read the article

• SQL Server 2000 restore error

  - by kv

  i'm trying to do point in time restore and following error occurs... and database goes into xxxxx(loading) state... Backup set cannot be applied because it is on a recovery path inconsistent with database i have to do RESTORE…

  Read the article

• MS SQL dts to ssis migration error

  - by Manjot

  Hi, I have migrated some DTS packages to SSIS 2005 using "Migration" wizard. When I tried to run it, it fails saying you need a higher version of SSIS even though the destination SSIS server is on 9.0.4211 level. then I…

  Read the article

• Sql Server database logs "missing"

  - by linkerro

  Here's the problem we're having: In the applications that are using the databases we get errors like: The log for database 'redactedDatabaseName' is not available. Check the event log for related error messages. Resolve…

  Read the article

< Previous Page | 73 74 75 76 77 78 79 80 81 82 83 84  | Next Page >