http://www.sqlmag.com/authors/author/author/5752019/rsscomment/5752019en-USFri, 25 May 2012 08:25:41 GMTFri, 25 May 2012 08:25:41 GMThttp://www.sqlmag.com/article/project-plan-backup-sql-server-2008-r2-83/sql-server/database-mirroring-in-sql-server-2008-and-sql-server-2008-r2#commentsAnchorTue, 21 Sep 2010 00:24:52 GMT
Very good article, sums up database mirroring in a very simple manner.]]>Mohammed MoinudheenTue, 21 Sep 2010 00:24:52 GMThttp://www.sqlmag.com/article/project-plan-backup-sql-server-2008-r2-83/sql-server/database-mirroring-in-sql-server-2008-and-sql-server-2008-r2#commentsAnchorhttp://www.sqlmag.com/article/data-access/sql-server-q-a#commentsAnchorThu, 24 Jul 2008 11:10:47 GMT
I’m very disappointed with the code presented in this article. It contains many errors. Anyway, the matter is interesting. Marcos Galvani MCDBA(SQL2k) MCTS (SQL2k3) marcosgalvani@gmail.com]]>MarcosThu, 24 Jul 2008 11:10:47 GMThttp://www.sqlmag.com/article/data-access/sql-server-q-a#commentsAnchorhttp://www.sqlmag.com/article/data-modeling/using-a-check-constraint-to-enforce-a-trigger-s-unique-value#commentsAnchorFri, 27 Apr 2007 14:08:32 GMT
Uhh... the title of this is "Using a CHECK Constraint to Enforce a Trigger’s Unique Value" if you download the sample code, a trigger is being used... since when is a trigger the same thing as a CHECK constraint? wtf??]]>PhilFri, 27 Apr 2007 14:08:32 GMThttp://www.sqlmag.com/article/data-modeling/using-a-check-constraint-to-enforce-a-trigger-s-unique-value#commentsAnchorhttp://www.sqlmag.com/article/passwords/answers-from-microsoft15803#commentsAnchorMon, 31 Jul 2006 16:06:41 GMT
Good answer. Good examples. Thanks Andre]]>AndreMon, 31 Jul 2006 16:06:41 GMThttp://www.sqlmag.com/article/passwords/answers-from-microsoft15803#commentsAnchorhttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorThu, 08 Sep 2005 08:28:33 GMT
I tried it, but I still get the message]]>Anonymous User Thu, 08 Sep 2005 08:28:33 GMThttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorhttp://www.sqlmag.com/article/ftp/using-dynamic-snapshot-for-merge-replication#commentsAnchorMon, 22 Aug 2005 15:50:45 GMT
AWESOME. RICHARD IS THE MOST GENIUS I KNOW. ARE YOU READY FOR TO DISS THE IPOD! I AM! ROCKS ON COMMANDOR IN CHIEFS (KASNSAS CITY)! I DON’T BELIEVE WE HAVE MET BEFORE - IS YOUR NAME FAT PIG? WHAT A GREAT TIME WE ALL ARE BEGINNING TO KNOW!]]>Anonymous User Mon, 22 Aug 2005 15:50:45 GMThttp://www.sqlmag.com/article/ftp/using-dynamic-snapshot-for-merge-replication#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/sql-server-q-a8040#commentsAnchorMon, 15 Aug 2005 15:13:08 GMT
bad formatting]]>Anonymous User Mon, 15 Aug 2005 15:13:08 GMThttp://www.sqlmag.com/article/systems-administrator/sql-server-q-a8040#commentsAnchorhttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorMon, 01 Aug 2005 13:59:28 GMT
Worked great! Wonder why this isn’t on MS KB?]]>Anonymous User Mon, 01 Aug 2005 13:59:28 GMThttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorhttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorTue, 14 Jun 2005 13:49:53 GMT
thanks a lot. Solved my problem!!]]>Anonymous User Tue, 14 Jun 2005 13:49:53 GMThttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft8647#commentsAnchorTue, 14 Jun 2005 02:15:16 GMT
could not start My service service on Local Computer .THE SERVICE DID NOT RETURN AN ERROR.This could be an internal windows error or an internal service error]]>Anonymous User Tue, 14 Jun 2005 02:15:16 GMThttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft8647#commentsAnchorhttp://www.sqlmag.com/article/tsql3/answers-from-microsoft21565#commentsAnchorMon, 23 May 2005 15:23:55 GMT
i’m trying to upload Access format data into SQL SErver 2000 Developer Edition and was wondering if the data should be stored in a special directory or is it okay to put it wherever the Upsizing Wizard puts it by default. i need the data to be available for modifications from different locations.]]>xxx,xxx Mon, 23 May 2005 15:23:55 GMThttp://www.sqlmag.com/article/tsql3/answers-from-microsoft21565#commentsAnchorhttp://www.sqlmag.com/article/tsql3/answers-from-microsoft21565#commentsAnchorMon, 23 May 2005 15:23:55 GMT
i’m trying to upload Access format data into SQL SErver 2000 Developer Edition and was wondering if the data should be stored in a special directory or is it okay to put it wherever the Upsizing Wizard puts it by default. i need the data to be available for modifications from different locations.]]>xxx,xxx Mon, 23 May 2005 15:23:55 GMThttp://www.sqlmag.com/article/tsql3/answers-from-microsoft21565#commentsAnchorhttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorSun, 22 May 2005 18:25:28 GMT
Great!!!!! Worked like a charm]]>Anonymous User Sun, 22 May 2005 18:25:28 GMThttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorhttp://www.sqlmag.com/article/activex/sql-server-q-a6121#commentsAnchorSun, 24 Apr 2005 03:51:32 GMT
HOW CAN I DETECT WHETHER SQL SERVER IS INSTALLED OR NOT? AND HOW CAN I RESTORE DATABASE INTO SERVER FROM CLIENT from Visual Basic6.0 (MS SQL SERVER 2000)]]>Anonymous User Sun, 24 Apr 2005 03:51:32 GMThttp://www.sqlmag.com/article/activex/sql-server-q-a6121#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/answers-from-microsoft20993#commentsAnchorTue, 12 Apr 2005 02:55:47 GMT
My Active Directory got corrupted and now my SQL Serve is giving me the problem that you can’t launch SQLSever Agent and EventID: 103 and EventID:19011. What also happens now is tnat, when I run My backps of the data, it only progreese to a certain stage and fails and the same with the restore prosses.]]>Anonymous User Tue, 12 Apr 2005 02:55:47 GMThttp://www.sqlmag.com/article/enterprise-manager/answers-from-microsoft20993#commentsAnchorhttp://www.sqlmag.com/article/log-files/accounting-for-transaction-log-growth#commentsAnchorWed, 02 Mar 2005 05:20:50 GMT
My transaction log for a DB has exceeded 37GB, the nature of our DB is not so senstive so I dont see a need to keep it at all, as to my understanding it only holds transaction history among tables. Can I just simply get rid of it by deleting it? How can deleting the transaction log affect my DB?]]>Anonymous User Wed, 02 Mar 2005 05:20:50 GMThttp://www.sqlmag.com/article/log-files/accounting-for-transaction-log-growth#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorTue, 01 Mar 2005 04:52:00 GMT
I want to retreive photos stored in the MS-Access Database using ASP. Please provide me help.]]>Anonymous User Tue, 01 Mar 2005 04:52:00 GMThttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft8647#commentsAnchorSun, 27 Feb 2005 05:26:27 GMT
dear team ii keep losing my media player a message comes up an intenall application error has occured can you help thanks jmgillam@tiscali.co.uk ]]>Anonymous User Sun, 27 Feb 2005 05:26:27 GMThttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft8647#commentsAnchorhttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorWed, 23 Feb 2005 12:20:45 GMT
very helpful, googled it right up]]>Anonymous User Wed, 23 Feb 2005 12:20:45 GMThttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/compression-log-files-and-more#commentsAnchorFri, 18 Feb 2005 10:51:11 GMT
Detach The Database from enterprise manager. Rename the log file. When you reattach - the log file will show with a red X. Then continue - this will give you a new log file.]]>Anonymous User Fri, 18 Feb 2005 10:51:11 GMThttp://www.sqlmag.com/article/enterprise-manager/compression-log-files-and-more#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/answers-from-microsoft20993#commentsAnchorTue, 08 Feb 2005 11:24:35 GMT
SuperSocket info: (SpnRegister) : Error 1355.]]>Anonymous User Tue, 08 Feb 2005 11:24:35 GMThttp://www.sqlmag.com/article/enterprise-manager/answers-from-microsoft20993#commentsAnchorhttp://www.sqlmag.com/article/tsql3/answers-from-microsoft15580#commentsAnchorTue, 01 Feb 2005 11:24:19 GMT
Please note that Cast(’100.00’ as numeric(7,2)) will also give an error. Any ideas? Mo’ ashedick@gmail.com]]>Anonymous User Tue, 01 Feb 2005 11:24:19 GMThttp://www.sqlmag.com/article/tsql3/answers-from-microsoft15580#commentsAnchorhttp://www.sqlmag.com/article/tsql3/answers-from-microsoft15580#commentsAnchorTue, 01 Feb 2005 11:08:14 GMT
Please note that Cast(’$100.00’ as numeric(7,2)) will also give an error. So the tab is not the issue. Any suggestions?]]>Anonymous User Tue, 01 Feb 2005 11:08:14 GMThttp://www.sqlmag.com/article/tsql3/answers-from-microsoft15580#commentsAnchorhttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorTue, 18 Jan 2005 11:56:21 GMT
This article helped out a BUNCH!!!.... I had been steared toward a conflict between Visio and SQL. A very complicated answer. This went straight to the point. Thanks ]]>Anonymous User Tue, 18 Jan 2005 11:56:21 GMThttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorhttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorThu, 13 Jan 2005 11:18:07 GMT
Excellent!! Resolved the issue for me...Thank you!]]>Anonymous User Thu, 13 Jan 2005 11:18:07 GMThttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/compression-log-files-and-more#commentsAnchorMon, 10 Jan 2005 18:16:08 GMT
try sp_detach sp_attach]]>Anonymous User Mon, 10 Jan 2005 18:16:08 GMThttp://www.sqlmag.com/article/enterprise-manager/compression-log-files-and-more#commentsAnchorhttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorThu, 30 Dec 2004 08:44:26 GMT
http://www.goat.cx]]>Anonymous User Thu, 30 Dec 2004 08:44:26 GMThttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorhttp://www.sqlmag.com/article/sql-server/reestablishing-stored-procedure-dependencies#commentsAnchorWed, 03 Nov 2004 15:25:35 GMT
THANKS - IT works GREAT!!!!]]>Anonymous User Wed, 03 Nov 2004 15:25:35 GMThttp://www.sqlmag.com/article/sql-server/reestablishing-stored-procedure-dependencies#commentsAnchorhttp://www.sqlmag.com/article/sql-server/reestablishing-stored-procedure-dependencies#commentsAnchorWed, 03 Nov 2004 14:54:56 GMT
try running sp_wtf]]>Anonymous User Wed, 03 Nov 2004 14:54:56 GMThttp://www.sqlmag.com/article/sql-server/reestablishing-stored-procedure-dependencies#commentsAnchorhttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorFri, 29 Oct 2004 21:51:36 GMT
help me solve the problem.]]>Anonymous User Fri, 29 Oct 2004 21:51:36 GMThttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorhttp://www.sqlmag.com/article/tsql3/answers-from-microsoft21565#commentsAnchorFri, 29 Oct 2004 04:15:30 GMT
Creating INSERT Statements: See http://vyaskn.tripod.com/code.htm#inserts]]>Anonymous User Fri, 29 Oct 2004 04:15:30 GMThttp://www.sqlmag.com/article/tsql3/answers-from-microsoft21565#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/compression-log-files-and-more#commentsAnchorTue, 20 Jul 2004 03:41:18 GMT
Shanawaj You cannot delete the log file in order to use the database, instead refer to the books online for DBCC SHRINKFILE in order to shrink the size of Trnasaciton log file or deploy SIMPLE recovery model on the database. HTH]]>SatyaTue, 20 Jul 2004 03:41:18 GMThttp://www.sqlmag.com/article/enterprise-manager/compression-log-files-and-more#commentsAnchorhttp://www.sqlmag.com/article/tcpip/failing-to-access-virtual-server#commentsAnchorThu, 01 Jul 2004 03:54:24 GMT
The article is excellent and so informative. Can we have more of that calibre. Good work]]>Tawanda Makawa Thu, 01 Jul 2004 03:54:24 GMThttp://www.sqlmag.com/article/tcpip/failing-to-access-virtual-server#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft8647#commentsAnchorMon, 28 Jun 2004 06:40:20 GMT
Your Comments (required):could not start the mssqlserver services on local computer. the service did not return an error this could be an internall error or internal service error if the problem perists contact your system administrator]]>krishnaMon, 28 Jun 2004 06:40:20 GMThttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft8647#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/answers-from-microsoft20888#commentsAnchorFri, 04 Jun 2004 23:50:17 GMT
BULK INSERT imgElu FROM ’D:\Host\ImageTable_File.txt’ WITH ( DATAFILETYPE = ’char’ , FIELDTERMINATOR = ’|’ , ROWTERMINATOR = ’\n’ ) when i execute this query i will get the following error message even in correct path and correct file specified Error Message Server: Msg 4861, Level 16, State 1, Line 1]]>JayaramanFri, 04 Jun 2004 23:50:17 GMThttp://www.sqlmag.com/article/visual-basic-vb/answers-from-microsoft20888#commentsAnchorhttp://www.sqlmag.com/article/sql-server-70/answers-from-microsoft9768#commentsAnchorThu, 03 Jun 2004 13:33:45 GMT
excelent and easy to understand, but i want know how can i have drivers for SQL*NET, because i don’t have this. If you can help me please.]]>Arturo Vega Thu, 03 Jun 2004 13:33:45 GMThttp://www.sqlmag.com/article/sql-server-70/answers-from-microsoft9768#commentsAnchorhttp://www.sqlmag.com/article/quering/inserting-an-image-into-a-column#commentsAnchorWed, 02 Jun 2004 12:04:13 GMT
hey don’t u people have new stuff . all these things are already in sql help . i want to know how will u save a picture file like abc.bmp,xyz.gif into image column of sql server. u people r just takeing saved picture from the sql server and again saving the same thing. its meaning less. i am sorry if i hurt]]>tirumalaWed, 02 Jun 2004 12:04:13 GMThttp://www.sqlmag.com/article/quering/inserting-an-image-into-a-column#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/answers-from-microsoft20888#commentsAnchorTue, 18 May 2004 09:53:56 GMT
I’m running SQL Server 2000 on a Windows 2000 Server and am trying to execute a simple Insert but get a similar message to the person above: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][SQL Server]xpsql.cpp: Error 997 from GetProxyAccount on line 472]]>Joel Bishop Tue, 18 May 2004 09:53:56 GMThttp://www.sqlmag.com/article/visual-basic-vb/answers-from-microsoft20888#commentsAnchorhttp://www.sqlmag.com/article/passwords/resetting-the-sql-server-service-account-password#commentsAnchorThu, 22 Apr 2004 19:20:58 GMT
Thanks, I thought I was in hot water!]]>michael Thu, 22 Apr 2004 19:20:58 GMThttp://www.sqlmag.com/article/passwords/resetting-the-sql-server-service-account-password#commentsAnchorhttp://www.sqlmag.com/article/com-and-com/determining-the-maximum-number-of-connections-to-sql-server-2000#commentsAnchorTue, 20 Apr 2004 07:53:34 GMT
Could you please explain what does a node means and what an instance of node means. Also i would like to know how is this relateed to the user licence]]>rajneeshTue, 20 Apr 2004 07:53:34 GMThttp://www.sqlmag.com/article/com-and-com/determining-the-maximum-number-of-connections-to-sql-server-2000#commentsAnchorhttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorTue, 30 Mar 2004 10:01:19 GMT
thankyou very much, i have the same problem, but i solved it quickly with its solution]]>Ubaldo Cornejo Tue, 30 Mar 2004 10:01:19 GMThttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorhttp://www.sqlmag.com/article/passwords/resetting-the-sql-server-service-account-password#commentsAnchorMon, 01 Mar 2004 10:15:09 GMT
That’s the information I needed. Thank you SO VERY much.]]>Kevin Goldberg Mon, 01 Mar 2004 10:15:09 GMThttp://www.sqlmag.com/article/passwords/resetting-the-sql-server-service-account-password#commentsAnchorhttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorMon, 23 Feb 2004 15:51:42 GMT
This article helped a alot.]]>Charles Weudner Mon, 23 Feb 2004 15:51:42 GMThttp://www.sqlmag.com/article/installation2/troubleshooting-a-sql-server-2000-installation-error-message#commentsAnchorhttp://www.sqlmag.com/article/tsql3/answers-from-microsoft9024#commentsAnchorTue, 10 Feb 2004 08:48:46 GMT
Thank you very much for this tip. It saved a hell of a lot of head scratching. Btw, if you have an automated process that switches sql server databases, you can issue a command such as ’USE master’ to ensure that the database you wish to work with isn’t locked.]]>JasonTue, 10 Feb 2004 08:48:46 GMThttp://www.sqlmag.com/article/tsql3/answers-from-microsoft9024#commentsAnchorhttp://www.sqlmag.com/article/passwords/answers-from-microsoft15803#commentsAnchorFri, 03 Oct 2003 05:42:38 GMT
This is not a comment first of all. It is a problem. In windows 2000 server, how to have a folder/file, which is accessible only to the creator and not even to the administrator. Because admin has got all the rights irrespective of the permissions granted. Isn’t it? If any answer?, please communicate. Regards]]>amanFri, 03 Oct 2003 05:42:38 GMThttp://www.sqlmag.com/article/passwords/answers-from-microsoft15803#commentsAnchorhttp://www.sqlmag.com/article/tsql3/answers-from-microsoft9024#commentsAnchorWed, 01 May 2002 15:55:36 GMT
HELP!!!! I’m trying to execute a DTS package that is extracting data from excel spreadsheets. some of them are working correctly, but others I am getting the following error message. The connection is currently being used by a task. The connection cannot be closed or reused. PLEASE HELP!!!!!!!!!!!!!!!!!!!!!!!]]>ShelleyWed, 01 May 2002 15:55:36 GMThttp://www.sqlmag.com/article/tsql3/answers-from-microsoft9024#commentsAnchorhttp://www.sqlmag.com/article/migration/web-sql-q-a5231#commentsAnchorWed, 10 Apr 2002 12:26:00 GMT
Regarding error #7353, "Server: Msg 7353, Level 16, State 1, Line 1 OLE DB provider ’SQLOLEDB’ supplied inconsistent meta data. An extra column was supplied during execution that was not found at compile time.". This error will also be encountered if you use the ’ALTER TABLE DROP COLUMN’ command on a table in the linked server’s database.]]>Frederick Wright Wed, 10 Apr 2002 12:26:00 GMThttp://www.sqlmag.com/article/migration/web-sql-q-a5231#commentsAnchorhttp://www.sqlmag.com/article/tsql3/answers-from-microsoft9024#commentsAnchorWed, 06 Mar 2002 15:02:09 GMT
The article or Q/A on SQL error 1069 saved my life. Thank you]]>Roger Gomez Wed, 06 Mar 2002 15:02:09 GMThttp://www.sqlmag.com/article/tsql3/answers-from-microsoft9024#commentsAnchorhttp://www.sqlmag.com/article/odbc/sql-server-q-a7454#commentsAnchorTue, 29 Jan 2002 06:28:34 GMT
We’ve seen the same problem on SQL 6.5 SP5a. See the following MS Knowledgebase articles: 1. Q178296 - SQL 6.5 Open Objects BUG... 2. Q114843 - Explanation of Open Objects in SQL Server ...still happening too. bumped up the open objects value in sp_configure.]]>MartinTue, 29 Jan 2002 06:28:34 GMThttp://www.sqlmag.com/article/odbc/sql-server-q-a7454#commentsAnchorhttp://www.sqlmag.com/article/scripting/eliminating-a-database-in-use-error-message-during-a-reload#commentsAnchorFri, 25 Jan 2002 09:50:42 GMT
from Master database I get error message - Server: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword ’set’. Server: Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ’immediate’.]]>Sue Royal Fri, 25 Jan 2002 09:50:42 GMThttp://www.sqlmag.com/article/scripting/eliminating-a-database-in-use-error-message-during-a-reload#commentsAnchorhttp://www.sqlmag.com/article/dts/running-a-dts-job-on-a-second-machine#commentsAnchorThu, 24 Jan 2002 11:32:29 GMT
I found it, it’s a bug KB: Q241643 BUG: 8198 Error Message Returned from Job Owned by Windows NT Authenticated User]]>James Pua Thu, 24 Jan 2002 11:32:29 GMThttp://www.sqlmag.com/article/dts/running-a-dts-job-on-a-second-machine#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorMon, 21 Jan 2002 05:12:52 GMT
I want to direct query results to a file for later use . Is there an easy way to direct SQL query output to a text file? I am using SQL server 7.0]]>KasiMon, 21 Jan 2002 05:12:52 GMThttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorhttp://www.sqlmag.com/article/dts/truncating-data#commentsAnchorThu, 03 Jan 2002 12:35:56 GMT
I use a DROP TABLE `results` (Execute SQL Task) as the first step of the DTS package (where "results" is the name of the sheet that contains the data in the excel spreadsheet). Make sure you set it to the Excel file connection (in my case, connection 2).]]>David Wood Thu, 03 Jan 2002 12:35:56 GMThttp://www.sqlmag.com/article/dts/truncating-data#commentsAnchorhttp://www.sqlmag.com/article/data-modeling/using-a-check-constraint-to-enforce-a-trigger-s-unique-value#commentsAnchorThu, 27 Dec 2001 09:01:46 GMT
--Forgot about updating to NULL. =Þ CREATE TRIGGER tr_BaseTable_iud ON BaseTable FOR INSERT, UPDATE, DELETE AS /* ** æ 12/26/01 org: Trig to maintain unique values. ** æ 12/27/01 Bug fix: UPDATE to NULL. */ SET NOCOUNT ON DELETE FROM ut FROM dbo.UniqueTable ut JOIN deleted d ON ut.unique1 = d.unique1 LEFT JOIN inserted i ON d.pkid = i.pkid WHERE i.unique1 IS NULL UPDATE ut SET ut.unique1 = i.unique1 FROM dbo.UniqueTable ut JOIN deleted d ON ut.unique1 = d.unique1 JOIN inserted i ON d.pkid = i.pkid WHERE d.unique1 <> i.unique1 AND i.unique1 IS NOT NULL INSERT INTO dbo.UniqueTable SELECT i.unique1 FROM inserted i LEFT JOIN deleted d ON i.pkid = d.pkid WHERE d.pkid IS NULL AND i.unique1 IS NOT NULL GO]]>Aaron Ellis Thu, 27 Dec 2001 09:01:46 GMThttp://www.sqlmag.com/article/data-modeling/using-a-check-constraint-to-enforce-a-trigger-s-unique-value#commentsAnchorhttp://www.sqlmag.com/article/data-modeling/using-a-check-constraint-to-enforce-a-trigger-s-unique-value#commentsAnchorWed, 26 Dec 2001 22:43:17 GMT
Although slightly more complicated, using a second table with a Unique index would help keep performance optimized regardless on the size on the base table: CREATE TABLE BaseTable( pkid int IDENTITY, data1 varchar(10) NULL, unique1 int NULL ) GO ALTER TABLE BaseTable ADD CONSTRAINT pk_BaseTable PRIMARY KEY ( pkid) GO CREATE TABLE UniqueTable( unique1 int NOT NULL ) GO ALTER TABLE UniqueTable ADD CONSTRAINT pk_UniqueTable PRIMARY KEY ( unique1) GO CREATE TRIGGER tr_BaseTable_iud ON BaseTable FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON DELETE FROM ut FROM dbo.UniqueTable ut JOIN deleted d ON ut.unique1 = d.unique1 LEFT JOIN inserted i ON d.pkid = i.pkid WHERE i.pkid IS NULL UPDATE ut SET ut.unique1 = i.unique1 FROM dbo.UniqueTable ut JOIN deleted d ON ut.unique1 = d.unique1 JOIN inserted i ON d.pkid = i.pkid WHERE d.unique1 <> i.unique1 INSERT INTO dbo.UniqueTable SELECT i.unique1 FROM inserted i LEFT JOIN deleted d ON i.pkid = d.pkid WHERE d.pkid IS NULL AND i.unique1 IS NOT NULL GO]]>Aaron Ellis Wed, 26 Dec 2001 22:43:17 GMThttp://www.sqlmag.com/article/data-modeling/using-a-check-constraint-to-enforce-a-trigger-s-unique-value#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/answers-from-microsoft8776#commentsAnchorWed, 28 Nov 2001 10:07:22 GMT
Does anyone know how to print a data transformation as a graphical output showing which fields from the source table are going to the fields in a destination table? Is there a tool that will doo that?]]>George Hendrickson Wed, 28 Nov 2001 10:07:22 GMThttp://www.sqlmag.com/article/stored-procedures/answers-from-microsoft8776#commentsAnchorhttp://www.sqlmag.com/article/migration/sql-server-q-a6206#commentsAnchorThu, 15 Nov 2001 13:56:07 GMT
Hello All Can anyone of you please let me know the best resource which gives step-by-step of migrating from SQL Server 7 to SQL Server 2000 ASAP. Thank you Siva Ram]]>Siva Ram Thu, 15 Nov 2001 13:56:07 GMThttp://www.sqlmag.com/article/migration/sql-server-q-a6206#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/compression-log-files-and-more#commentsAnchorSat, 10 Nov 2001 09:38:05 GMT
I have one Query, Please answer me. I am using SQL2000. I have 15 databases, the transations are too huge. My log files are getting increased, nearly 700 MB. How can I delete the log file. Waiting for the reply.]]>Shanawaj Sat, 10 Nov 2001 09:38:05 GMThttp://www.sqlmag.com/article/enterprise-manager/compression-log-files-and-more#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/answers-from-microsoft8776#commentsAnchorWed, 24 Oct 2001 09:08:39 GMT
How can you call the sp_setapprole system stored procedure within a SQL user defined stored procedure]]>Nathan Ragsdale Wed, 24 Oct 2001 09:08:39 GMThttp://www.sqlmag.com/article/stored-procedures/answers-from-microsoft8776#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorSun, 21 Oct 2001 23:21:43 GMT
How can I find the path of osql.exe programmatically? Is there a means by which I could do it?]]>Bunty Parekh Sun, 21 Oct 2001 23:21:43 GMThttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorSat, 20 Oct 2001 12:41:34 GMT
Is possible to insert records in middle of the recordset in SQL Server? I mean, i have 1 to 5 records. i want to add new record between 1 and 3. Is atleast possible in Enterprise Manager?]]>chitra Sat, 20 Oct 2001 12:41:34 GMThttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorSat, 20 Oct 2001 12:31:52 GMT
whats difference between ORACLE and SQL Server? Which have more feature?]]>chitra Sat, 20 Oct 2001 12:31:52 GMThttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorSat, 20 Oct 2001 12:27:54 GMT
select 5/100 select conver(float,(5/100)) select abs(conver(float,(5/100))) result is 0.0 I couldn’t get the exact(0.05) answer. Can u help me plz?]]>chitra Sat, 20 Oct 2001 12:27:54 GMThttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorhttp://www.sqlmag.com/article/scripting/eliminating-a-database-in-use-error-message-during-a-reload#commentsAnchorMon, 08 Oct 2001 14:13:06 GMT
i could not get this to work. i was in master, and i included the dbname (not master) in the statement and got incorrect syntax near the keyword ’ROLLBACK’, same for ’IMMEDIATE’]]>Doug Fala Mon, 08 Oct 2001 14:13:06 GMThttp://www.sqlmag.com/article/scripting/eliminating-a-database-in-use-error-message-during-a-reload#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/sql-server-q-a-answers-from-microsoft#commentsAnchorTue, 17 Jul 2001 08:13:13 GMT
I cannot see table alias names from an IBM DB2 database when trying to import data into SQL2000 using DTS. Is there a possible workaround this problem?]]>mike draghici Tue, 17 Jul 2001 08:13:13 GMThttp://www.sqlmag.com/article/systems-administrator/sql-server-q-a-answers-from-microsoft#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/answers-from-microsoft8776#commentsAnchorWed, 13 Jun 2001 09:12:20 GMT
I am pulling data out of a table and need to put a time stamp and the number of rows at the head of the file. How do I go about doing this? i.e. 06/12/2001 10 Rows row 1 row 2 row 3 ... etc]]>Ashish Kaushal Wed, 13 Jun 2001 09:12:20 GMThttp://www.sqlmag.com/article/stored-procedures/answers-from-microsoft8776#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/answers-from-microsoft20244#commentsAnchorThu, 26 Apr 2001 11:16:21 GMT
On the script for how to pad out the spaces on a variable length column, I use a different approach. The method shown works only if all of the data in the column is a known quantity. The following script does the same job but is more flexible: UPDATE mytable1 SET c1 = CONVERT(char(220), c1) or UPDATE mytable1 SET c1 = CAST( c1 as char(220) )]]>Colin Blair Thu, 26 Apr 2001 11:16:21 GMThttp://www.sqlmag.com/article/enterprise-manager/answers-from-microsoft20244#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorMon, 16 Apr 2001 06:51:09 GMT
I am using ASP to validate the user’s Login_name and Password in the SQL database. But the ASP contain the database, ID, password of the SQL data. I think it is NOT secure to keep these info in the ASP code, what is best solution. See my ASP code below: Set Cn = Server.CreateObject("ADODB.Connection") Cn.Open "Provider=SQLOLEDB;Server=xx.xxx.xxx.x;" & "Database=xxxx;User Id=xxxx;Password=xxxx;" Set Rs = Server.CreateObject("ADODB.Recordset") strDB = "execute sp_login ’" & strUserName & "’" & ",’" & strPassword & "’" Rs.Open strDB, Cn, 0, 1 if (Not RS.EOF) then if (RS("acc_lock")<>True) Then if (Trim(Rs("password"))=strPassword) Then ’User is validated!]]>sl Mon, 16 Apr 2001 06:51:09 GMThttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorhttp://www.sqlmag.com/article/permissions/answers-from-microsoft16358#commentsAnchorMon, 29 Jan 2001 10:15:35 GMT
You used to be able to use Visual Interdev (data project) and Visual Source Safe to control stored procedures and it works well. You may have noticed dt_.... stored procedures appearing in your database, these are put there by interdev for this purpose. However you need to install interdev server and a few other bits. Look at ReadMevi.htm on Disk1 of Visual Studio 6.]]>Simon Sabin Mon, 29 Jan 2001 10:15:35 GMThttp://www.sqlmag.com/article/permissions/answers-from-microsoft16358#commentsAnchorhttp://www.sqlmag.com/article/performance/websql-q-a#commentsAnchorSun, 05 Nov 2000 21:39:38 GMT
Is it possible to run a DTS Package from a stored procedure . Thanks]]>Peter PIerre Sun, 05 Nov 2000 21:39:38 GMThttp://www.sqlmag.com/article/performance/websql-q-a#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchorThu, 31 Aug 2000 01:02:14 GMT
I don’t like it when I find: "... a problem in SQL Server 6.5 and 7.0 ... Microsoft fixed the problem in SQL Server 2000 ..."]]>Gheorghe Petrescu Thu, 31 Aug 2000 01:02:14 GMThttp://www.sqlmag.com/article/systems-administrator/answers-from-microsoft#commentsAnchor