Archive

RSSBlogEngine.NET (0)

Date Title Comments Rating

RSSDOS (2)

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

RSSERRORs (3)

Date Title Comments Rating
2011-01-27 Msg 7415, Level 16, State 1, Line 1. Ad hoc access to OLE DB provider ' MSDASQL' has been denied. 0 None
2010-03-17 Msg 1934, Sev 16: UPDATE STATISTICS failed because the following SET options have incorrect settings: 'ARITHABORT'. 0 None
2008-10-20 Msg: 8501 SQL 2000 on Windows 2000 server 0 None

RSSETL (1)

Date Title Comments Rating
2008-02-01 Quickly import EXCEL data to tempdb table and script out field descriptor 0 None

RSSEXCEL (2)

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

RSSFiles (3)

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

RSSHTML (1)

Date Title Comments Rating
2008-09-23 Web colors 0 None

RSSMAC (1)

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

RSSPowerShell (1)

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

RSSServices (1)

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

RSSSQL (44)

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

RSSSQL Server (20)

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

RSSSQLAgent (4)

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

RSSSQLCMD (1)

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

RSSSSIS (1)

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

RSSWEB (1)

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

RSSWINDOWS (3)

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

Uncategorized (9)

Date Title Comments Rating
2009-04-08 OPENDATASOURCE connect to SQL Server 0 None
2008-08-03 Import Blogger blogs? 1 None
2008-08-03 "Your login attempt was not successful. Please try again." 0 None
2008-07-02 SQL Agent - job history set number of rows 0 None
2008-02-07 SQLCMD Login/User create template 0 4
2008-02-07 NT Login permissions trump NT Group 0 None
2008-01-22 Supported SQLCMD Syntax 0 None
2007-09-18 USAGE: xp_dirtree 0 None
2007-06-14 SQL 2000 Error: MSDTC on server 'YourSQLServerName' is unavailable. 0 None

Total

72 posts
1 comments
8 raters