SQL Server 2005

Welcome to the 'SQL Server 2005' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'SQL Server 2005'.

Latest blogosphere posts tagged “SQL Server 2005”

• SQL Server 2005 Diagnostic Information Queries

  
  Glenn Berry's SQL Server Performance — Authority: 121
  Here is an updated version of my diagnostic information queries for SQL Server 2005. You can get the SQL Server 2008 version here . Most of the DMV queries require VIEW SERVER STATE permission. -- SQL Server 2005 Diagnostic Information Queries-- Glenn Berry -- November 2009-- ...
  6 hours ago

• Fix for ‘The database principal owns a schema in the database, and cannot be dropped’ Error in SQL Server 2005

  
  Microsoft Technology, .Net, BizTalk, Sharepoint & etc. — Authority: 120
  It happens when you are trying to delete a SQL user. To change the DB_Owner to some another “Database Principal”; simply Drill Down to your Database in Sql Server Management Studio and further more Drill Down to your_DB_Name >Security > Schemas > db_owner > right click > select properties. You would ...
  1 day ago

• Restoring a database backup in .BAK format using SQL Server 2005

  
  MSMVPS.COM — Authority: 642
  In most cases, you will be able to properly restore a SQL Server backup file in .BAK format using SQL Server 2005. But sometimes you will encounter the following error Read More
  4 days ago

• SQL Server 2005 on Windows 2008 64 bit SP2. Installation issue

  
  IT answers — Authority: 458
  New Question Created by Jabba123
  5 days ago

• How to export/ import userschema in SQL server 2005?

  
  IT answers — Authority: 458
  New Question Created by Saimadhu
  5 days ago

• SQL University: Multiple Paths and Ownership Chaining

  
  K. Brian Kelley - Databases, Infrastructure, and Security — Authority: 120
  Welcome back to our last class this term on security in SQL Server here at SQL University . According to the syllabus , you should be picking up history next week with Jorge Segarra. SQL Server has a rich history. I know youll enjoy the coming week. However, before we move on, lets close on some intermediate ...
  1 week ago

• SQL 2005 will not recognize other local disks

  
  IT answers — Authority: 458
  New Question Created by Rick2766
  1 week ago

• How to export excel data to Sql server 2005

  
  IT answers — Authority: 458
  New Question Created by Rasheed180207
  1 week ago

• Snags With Profiler GUI

  
  Home of the Scary DBA — Authority: 470
  Running the Profiler GUI against a production server is not something you should do. I’ve outlined my research into exactly why in the past . But I hit another little issue with the Profiler GUI as part of work I’m doing on a Microsoft PSS call (more on that in another post). We have a procedure on one of our ...
  1 week ago

• SQL University: Diving into Authorization

  
  K. Brian Kelley - Databases, Infrastructure, and Security — Authority: 120
  Its good to see all your bright and chipper faces here at SQL University . Hopefully youve digest Mondays lesson on Authentication . Today were going to discuss Authorization. Now Authorization can only take place after Authentication has been accomplished. If SQL Server doesnt know who you are, it cant determine ...
  1 week ago

• SQL Snippets is my new favourite thing.

  
  SQLServerPedia — Authority: 145
  Within the last hour, Mladen Prajdić announced a new version of his popular SSMS Tools Pack version 1.7. The main new feature being SQL Snippets. This provides Management Studio an add-in that is very much like the code snippets in other IDEs everywhere. Also within that last hour, Ive installed and test-driven ...
  2 weeks ago

• Database restore

  
  IT answers — Authority: 458
  New Question Created by Thedbaed
  2 weeks ago

• Auditing Windows 2003 and MS SQL 2005

  
  IT answers — Authority: 458
  New Question Created by Gideont
  2 weeks ago

• SQL Azure October 2009 CTP Signup Clarification

  
  OakLeaf Systems — Authority: 527
  If you have a SQL Server Data Services (SSDS), SQL Data Services (SDS), or SQL Azure August or earlier CTP account, you’ll probably receive (or have received) mail similar to the following from the ssdstlk@microsoft.com alias: Following the https://sal.azure.com link leads to you the new SQL Azure ...
  2 weeks ago

• Characters

  
  Home of the Scary DBA — Authority: 470
  No, I’m not talking about a Dickens novel. I’m talking about the number of characters in a string. I had a painful time recently because of the word “characters.”  If you take a look at the dynamic management view sys.dm_exec_sql_text you can get the queries that have been run on your system that are still ...
  2 weeks ago

• Characters

  
  SQLServerPedia — Authority: 145
  No, I’m not talking about a Dickens novel. I’m talking about the number of characters in a string. I had a painful time recently because of the word “characters.”  If you take a look at the dynamic management view sys.dm_exec_sql_text you can get the queries that have been run on your system that are still ...
  2 weeks ago

• Free Training RIGHT NOW

  
  Home of the Scary DBA — Authority: 470
  Quest Connect 2009 is occurring even as I type this. Get on over there if you’re interested in some free training. I recorded a session on understanding execution plans. But even better, there are live sessions with some great people. Stop reading this, click the link, get yourself some free training.
  2 weeks ago

• ASP.Net, Java Script, SharePoint Designer jobs, walkin on 24th Oct 09

  
  CareerGuruz.Com — Authority: 146
  Sharepoint- Sr.Consultant Qualification: Any Graduate Exp: 2+yrsJob Description:-4-6 years of total experience in which at least 2 years in MOSS 2007 and Min 4 Years SharePoint Experience-Atleast 2 years of exp in SharePoint Designer, Web Part, CAML, Work flows, Search, Infopath-Good Experience on Sharepoint ...
  2 weeks ago

• SQL Server 2005 SP3 CU6 Released

  
  Glenn Berry's SQL Server Performance — Authority: 121
  Microsoft released Cumulative Update 6 for SQL Server 2005 SP3 yesterday (and the KB link is working today). This is Build 4266. There are over twenty fixes included in the CU, including a couple for database mirroring. All of the post-SP3 builds are listed here . They also released CU 16 for SQL Server 2005 SP2, ...
  2 weeks ago

• SQL Server 2005 distribution agent failed

  
  IT answers — Authority: 458
  New Question Created by ITKE
  3 weeks ago

Comments about SQL Server 2005