Archive

RSSBlogEngine.NET (0)

Date Title Rating

RSSDOS (2)

Date Title Rating
2009-07-03 [Microsoft][SQL Native Client]Unable to open BCP host data-file None
2007-09-20 USAGE: SQLCMD DOS Commands from T-SQL Script None

RSSERRORs (2)

Date Title Rating
2010-03-17 Msg 1934, Sev 16: UPDATE STATISTICS failed because the following SET options have incorrect settings: 'ARITHABORT'. None
2008-10-20 Msg: 8501 SQL 2000 on Windows 2000 server None

RSSEXCEL (2)

Date Title Rating
2009-07-03 Import EXCEL data using OPENDATASOURCE None
2008-09-05 INSERT data from SQL table to EXCEL None

RSSFiles (3)

Date Title Rating
2010-02-01 Links to help explain RAID None
2009-06-25 Hello World, Filesystemobject using sp_OA procedures None
2008-10-22 BCP out table data with Column Names None

RSSHTML (1)

Date Title Rating
2008-09-23 Web colors None

RSSMAC (1)

Date Title Rating
2008-08-23 Change mouse cursor size None

RSSPowerShell (1)

Date Title Rating
2010-08-04 PowerShell and why I will learn it. None

RSSServices (1)

Date Title Rating
2007-07-13 SQL 2000 Error: MSDTC on server 'YourSQLServerName' is unavailable. None

RSSSQL (44)

Date Title Rating
2010-05-11 A good article on SQL Transactions None
2010-03-24 Open DBDiff - a viable alternative? None
2010-03-17 Msg 1934, Sev 16: UPDATE STATISTICS failed because the following SET options have incorrect settings: 'ARITHABORT'. None
2010-03-04 Getting started in SSIS dynamic packages None
2009-12-31 Use COALESCE to put a column of data into a delimited list variable None
2009-12-28 Can we use the SQL 2005 engine for queries against a SQL 2000 linked server? None
2009-09-02 [ODBC Driver Manager] Driver does not support this function ... 'MSDASQL' IDBInitialize::Initialize None
2009-07-03 Import EXCEL data using OPENDATASOURCE None
2009-07-03 Linked Server - commands, one hop None
2009-07-03 [Microsoft][SQL Native Client]Unable to open BCP host data-file None
2009-06-25 Hello World, Filesystemobject using sp_OA procedures None
2009-05-13 Dynamic SQL test for data (EXISTS) script None
2009-05-12 @@ROWCOUNT output, the given choice for standard out logging None
2009-04-21 OPENROWSET to text file fails with Msg 7399 Could not find installable ISAM None
2009-04-16 Remove table owner and quoted identifiers None
2009-04-16 ERROR: OLE/DB provider returned message: [Microsoft][ODBC Text Driver] System resource exceeded None
2009-04-02 SQL Server - What am I running? Configurations. None
2009-04-02 T-SQL - fn_GetCurrentSQL None
2009-04-02 T-SQL - sp__who2 None
2009-02-11 Test for Linked Server connectivity None
2009-01-22 T-SQL tutorials - what a find. None
2009-01-06 Msg 229 ... EXECUTE permission was denied on the object 'xp_cmdshell' None
2008-11-21 T-SQL Searching using Wildcard Characters None
2008-11-14 List Database Recovery Mode on a server None
2008-11-12 Rename a SQL Server, steps. None
2008-10-31 SQL Server reading list None
2008-10-28 Using SQLAgent Tokens - Automatically add a schedule None
2008-10-22 BCP out table data with Column Names None
2008-10-20 Msg: 8501 SQL 2000 on Windows 2000 server None
2008-10-09 SQL Code HTML formatter None
2008-10-06 SQL Server 2005 SP2 download. None
2008-10-05 Open a text file using OPENROWSET and OPENDATASOURCE None
2008-10-02 How do NULLs behave using GROUP BY or DISTINCT? None
2008-09-29 tempdb file usage None
2008-09-23 SQL table column information None
2008-09-19 SQL Index Tuning Wizard - Create a Profiler trace file for None
2008-09-09 SQL Conversions - Hex to Int etc. None
2008-09-09 General Tips on Optimizing SQL Server Indexes None
2008-09-08 Index Fillfactor None
2008-09-05 INSERT data from SQL table to EXCEL None
2008-09-02 An idle CPU condition has not been defined None
2007-10-26 CONSTRAINT or INDEX? None

RSSSQL Server (20)

Date Title Rating
2010-08-04 PowerShell and why I will learn it. None
2010-07-13 Granting ASP.NET web application access to run procedures in SQL None
2010-02-01 Links to help explain RAID None
2009-09-02 [ODBC Driver Manager] Driver does not support this function ... 'MSDASQL' IDBInitialize::Initialize None
2009-04-21 OPENROWSET to text file fails with Msg 7399 Could not find installable ISAM None
2009-04-16 ERROR: OLE/DB provider returned message: [Microsoft][ODBC Text Driver] System resource exceeded None
2009-04-09 PC seems to hang using SSMS? Saving autorecovery information? None
2009-04-07 NOTE: Failed to notify 'operator' via email. None
2009-04-02 SQL Server - What am I running? Configurations. None
2009-03-31 SQL Log File Optimization. Check/fix your internal fragmentation None
2009-02-24 SQL Server Licensing None
2009-02-11 Test for Linked Server connectivity None
2009-01-12 Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 42 None
2009-01-06 Create a linked server to a local directory path None
2008-11-25 SQL limitations columns sizes etc. None
2008-11-25 Can't drop or edit SQL Agent job after changing server name None
2008-11-12 Rename a SQL Server, steps. None
2007-07-13 SQL 2000 Error: MSDTC on server 'YourSQLServerName' is unavailable. None

RSSSQLAgent (5)

Date Title Rating
2010-03-17 Msg 1934, Sev 16: UPDATE STATISTICS failed because the following SET options have incorrect settings: 'ARITHABORT'. None
2009-04-07 NOTE: Failed to notify 'operator' via email. None
2008-10-31 Installing SQL 2005 Performance Dashboard Reports None
2008-10-28 Using SQLAgent Tokens - Automatically add a schedule None

RSSSQLCMD (1)

Date Title Rating
2007-09-20 USAGE: SQLCMD DOS Commands from T-SQL Script None

RSSSSIS (1)

Date Title Rating
2010-03-04 Getting started in SSIS dynamic packages None

RSSWEB (1)

Date Title Rating
2010-07-13 Granting ASP.NET web application access to run procedures in SQL None

RSSWINDOWS (3)

Date Title Rating
2010-02-01 Links to help explain RAID None
2009-04-16 ERROR: OLE/DB provider returned message: [Microsoft][ODBC Text Driver] System resource exceeded None
2008-11-28 My Windows Explorer settings None

Total

70 posts

0 raters
Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2010 The SQL DBA