]]>happykakaTue, 29 Dec 2009 03:38:54 GMThttp://www.sqlmag.com/article/passwords/i-ve-forgotten-the-sa-password-for-sql-server-what-can-i-do-#commentsAnchorhttp://www.sqlmag.com/article/passwords/i-ve-forgotten-the-sa-password-for-sql-server-what-can-i-do-#commentsAnchorFri, 04 Dec 2009 02:24:50 GMT
http://blog.passwordunlocker.com/?p=13 there is an article about how to change sa password. Personally, I like to use MS SQL Server Password Unlocker, which is fast and easy to use. Just on mouse click, I change the lost sa password. You can download this sa password recovery tool at http://www.passwordunlocker.com/sql-server-password-unlocker.html]]>happykakaFri, 04 Dec 2009 02:24:50 GMThttp://www.sqlmag.com/article/passwords/i-ve-forgotten-the-sa-password-for-sql-server-what-can-i-do-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/does-sql-server-support-before-and-after-pre-and-post-triggers-what-about-row-vs-set-triggers-#commentsAnchorThu, 12 Nov 2009 14:09:41 GMT
technically sounds good. I would share wonderful resource for IT Support Services]]>contactsophie Thu, 12 Nov 2009 14:09:41 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/does-sql-server-support-before-and-after-pre-and-post-triggers-what-about-row-vs-set-triggers-#commentsAnchorhttp://www.sqlmag.com/article/configuration/how-can-i-convert-a-sql-date-time-to-just-date-#commentsAnchorWed, 16 Sep 2009 10:10:41 GMT
Here is how i would just get the date out of a long date. declare @NewDate varchar(10) select @NewDate = convert(varchar(10),getdate(),101)]]>JamesWed, 16 Sep 2009 10:10:41 GMThttp://www.sqlmag.com/article/configuration/how-can-i-convert-a-sql-date-time-to-just-date-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-calculate-someone-s-age-in-sql-server-#commentsAnchorMon, 06 Oct 2008 11:57:52 GMT
Dear symlink, your code fails for leap year calculations, try ’19880229’ and ’20110228’.]]>ErikMon, 06 Oct 2008 11:57:52 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-calculate-someone-s-age-in-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorWed, 25 Jun 2008 13:00:41 GMT
I had the same issue and just identified a solution. I first checked the sql service account (windows login that runs the mssqlserver service). Before reading this article, I added this account to the destination server and granted it access to the share, to no avail. That would have solved the problem for most of the people that had this issue if they hadnt already figured it out....for the people that are aggravated because they still have the issue, try this.... exec xp_cmdshell ’dir \\server\share\’ When i ran that, i receieved error: Logon failure: the specified account password has expired. Bingo. I wouldnt have known that unless i actually tried to log into the server as the service account. I had only created a mapped drive using the service account credentials to test it, and it did not prompt me to change the password. (the user i created on the destination to match the service account had "change password on next logon" checked. So it was still a valid user with access to the unc path, but i still had an issue.]]>jeremygiaco Wed, 25 Jun 2008 13:00:41 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorhttp://www.sqlmag.com/article/passwords/i-ve-forgotten-the-sa-password-for-sql-server-what-can-i-do-#commentsAnchorFri, 15 Feb 2008 19:18:35 GMT
aa]]>snmatus Fri, 15 Feb 2008 19:18:35 GMThttp://www.sqlmag.com/article/passwords/i-ve-forgotten-the-sa-password-for-sql-server-what-can-i-do-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-equivalent-of-the-iif-command-in-sql-server-#commentsAnchorMon, 28 Jan 2008 23:47:55 GMT
SELECT CASE WHEN sum(SALARY)> 66000 THEN ’YES’ ELSE ’NO’ END AS SALARY from emp]]>rajeshmani Mon, 28 Jan 2008 23:47:55 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-equivalent-of-the-iif-command-in-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/my-sql-server-database-has-been-marked-loading-what-can-i-do-#commentsAnchorThu, 25 Oct 2007 16:10:09 GMT
If someone has attempted to restore a SQL Server backup with the "NORECOVERY" option, the restored database will remain in the "loading" state. Complete the restore with, RESTORE [DATABASE] WITH RECOVERY and it will be useable (although no more logs can be restored to it in the future).]]>DanThu, 25 Oct 2007 16:10:09 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/my-sql-server-database-has-been-marked-loading-what-can-i-do-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-use-lotus-notes-for-sql-mail-#commentsAnchorFri, 30 Mar 2007 13:00:48 GMT
Currently we are running SQL Server 2000 (enterprise) and Lotus Notes 6.5. Can I able to use Lotus Notes for SQL Mail. If so should I follow Option 1 How compatible SQL 2000 with Lotus Notes 6.5 If you could reply that would be great vveeraneni@nan.net Thanks, Ven]]>venFri, 30 Mar 2007 13:00:48 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-use-lotus-notes-for-sql-mail-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-select-random-rows-from-a-sql-server-table-#commentsAnchorWed, 21 Mar 2007 22:40:46 GMT
excellent]]>ClaudiaWed, 21 Mar 2007 22:40:46 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-select-random-rows-from-a-sql-server-table-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorTue, 13 Mar 2007 18:37:36 GMT
The suggestions in the OP were cryptic and ultimately didn’t work. However, the response about using xp_cmdshell to do a "net use" of the drive worked excellent! I did have to figure out how to *enable* xp_cmdshell but that was pretty easy to find. Great idea and made short work of the problem, as nothing had to be done to the "target" machine at all...]]>joeTue, 13 Mar 2007 18:37:36 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-calculate-someone-s-age-in-sql-server-#commentsAnchorMon, 05 Feb 2007 05:25:50 GMT
DateDiff counts the number of ’boundaries’ ie 30Dec to 01 Jan is 1 year, 30Apr to 1 May is 1 month. Heres how to calc an age ,which is a bit more readable, ive also used the original suggestions , and provided proof in a script. create function udfGetAgeAt(@Dob smalldatetime,@DateAt smalldatetime) returns integer as begin Declare @YearAdj integer if(datepart(dy,@Dob)>datepart(dy,@DateAt)) begin Select @YearAdj = -1 end else begin Select @YearAdj =0 end return datediff(yy,@dob,@Dateat)+@YearAdj end go create function npGetAt(@D1 smalldatetime,@D2 smalldatetime) returns integer as begin declare @YearRet integer select @yearret = CASE WHEN dateadd(year, datediff (year, @d1, @d2), @d1) > @d2 THEN datediff (year, @d1, @d2) - 1 ELSE datediff (year, @d1, @d2) END return @YearRet end go create procedure testdate @d1 smalldatetime,@d2 smalldatetime as Select Age = datediff(yy,@d1,@d2) Select dbo.udfGetAgeAt(@d1,@d2) Select dbo.npGetAt(@d1,@d2) Select datediff(month,@d1,@d2)/12 go -- Proof -- Case 1 : 1 Day before 1st birthday - Born 01may exec testdate ’01-may-2005’,’30-apr-2006’ -- Case 2 : 1 Day after 1st birthday - Born 01May exec testdate ’01-may-2005’,’02-may-2006’ -- Case 3 : On 1st birthday - Born 01May exec testdate ’01-may-2005’,’01-may-2006’ -- Case 4 : 1 Day before 1st birthday - Born 01Jan exec testdate ’01-jan-2005’,’30-dec-2005’ -- Case 5 : 1 Day after 1st birthday - Born 01Jan exec testdate ’01-jan-2005’,’02-jan-2006’ -- Case 6 : on 1st birthday - Born 01Jan exec testdate ’01-jan-2005’,’01-jan-2006’ -- Case 7 : 1st Day Of bday month - Born 30apr exec testdate ’30-apr-2005’,’01-apr-2006’]]>DaveMon, 05 Feb 2007 05:25:50 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-calculate-someone-s-age-in-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorThu, 07 Dec 2006 04:36:26 GMT
Sorry, last correction: if the tables don’t have unique indexes... then there’s no way of knowing if their contents are the same other than using bcp or some cursor.]]>bobbleball Thu, 07 Dec 2006 04:36:26 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorThu, 07 Dec 2006 02:27:27 GMT
hmm all right, having thought it out, if the tables don’t have unique indexes, all five counts have to be the same: select count(*) from tableA select count(*) from tableB select count(*) from (select distinct * from tableA) as a select count(*) from (select distinct * from tableB) as b select count(*) from (select * from tableA UNION select * from tableB) as t]]>bobbleball Thu, 07 Dec 2006 02:27:27 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorThu, 07 Dec 2006 02:16:42 GMT
wtf? it does work, the 3rd count would return 2 rows while 1st and 2nd would return 3]]>bobbleball Thu, 07 Dec 2006 02:16:42 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorhttp://www.sqlmag.com/article/configuration/how-can-i-convert-a-sql-date-time-to-just-date-#commentsAnchorMon, 04 Dec 2006 05:11:11 GMT
The site below indicates the parameter values used by MS-SQL for determining the convert output function. http://msdn2.microsoft.com/en-us/library/ms174450.aspx]]>AbrahamMon, 04 Dec 2006 05:11:11 GMThttp://www.sqlmag.com/article/configuration/how-can-i-convert-a-sql-date-time-to-just-date-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorWed, 21 Jun 2006 11:28:39 GMT
Look... You’ll notice that this magazine is called "Windows IT *PRO*", not "Windows IT Beginner". Asking a question about an article is fine, but the fact that you have the nerve to be *indignant* about the fact that you don’t understand a technical definition of a technical concept written for "Windows IT **Professionals**" is pathetic. Not knowing what a loopback interface is doesn’t make you an idiot, not knowing how to ask without being a jerk makes you an idiot. Now that we’ve gotten that out of the way, here we go. Definitions- Network Card: A physical card in the computer connected to a network. Network Interface: Simply the label your computers uses for the card&the network settings for the card. Let’s say you have just put in a second network card in the pci0 in your computer. Windows will say "Oh look, new hardware... alright it’s a network card. Ok, I’ve got the drivers right here. Let’s call this one "Local Area Connection 2". And then if you right click on local area connection 2 in your network connections thing, and select properties, you’ll see all of the settings that windows applied to it. A network interface is what your computer uses to reach a network, through a network card. Loopback is a SPECIAL network interface. Instead of connecting the computer to a network, it just sends the data back to the computer. You have a web server, from the server you wanted to view the webpage, you wouldn’t need a network card for that. Just point your webbrowser at the "Loopback address" (127.0.0.1) and it will make your browser *think* it’s going out over the net and getting a webpage, but it’s really just going to a fake network interface which is sending the info right back at you. Just like if you have a DB srver on your comp... to cnnct, you need a db client whch expects a network cnnctn. If access it frm the same machine, just point the client at 127.0.0.1 & it will think that it is connecting to a network, but it’s connecting to itself!]]>unix_is_better_than_win32 Wed, 21 Jun 2006 11:28:39 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorWed, 24 May 2006 02:58:44 GMT
Very useful. You have solved my problem]]>josepbocanegra Wed, 24 May 2006 02:58:44 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/configuration/how-can-i-convert-a-sql-date-time-to-just-date-#commentsAnchorWed, 22 Feb 2006 12:53:43 GMT
How do I change the code below to filter on today’s current date...not 2002-02-22 SELECT TOP 100 PERCENT UserID, LogonTime, IP, ContextID, ’LA_LA_’ AS ClientID, SessionID FROM AAA.dbo.OnlineUser WHERE CAST(FLOOR(CAST(LogonTime AS float)) AS datetime) = ’2002-02-22’]]>rushtons Wed, 22 Feb 2006 12:53:43 GMThttp://www.sqlmag.com/article/configuration/how-can-i-convert-a-sql-date-time-to-just-date-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-use-lotus-notes-for-sql-mail-#commentsAnchorWed, 18 Jan 2006 08:06:04 GMT
Would this be applicable for SQL Server 2000 ? I have have SQL2000 ,and i need to send mail via LOTUS (not configured as SMTP/PO3) .So i think your tips may help. Pleae advice more on this. this is very urgent, Thanks rajiv]]>adfasdWed, 18 Jan 2006 08:06:04 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-use-lotus-notes-for-sql-mail-#commentsAnchorhttp://www.sqlmag.com/article/sql-server-70/what-are-good-sql-server-books-and-other-sources-of-reference-#commentsAnchorTue, 15 Nov 2005 07:35:46 GMT
Maaan these links are old!]]>SeánTue, 15 Nov 2005 07:35:46 GMThttp://www.sqlmag.com/article/sql-server-70/what-are-good-sql-server-books-and-other-sources-of-reference-#commentsAnchorhttp://www.sqlmag.com/article/configuration/how-can-i-convert-a-sql-date-time-to-just-date-#commentsAnchorTue, 25 Oct 2005 07:37:22 GMT
See this Microsoft link for all the CONVERT datetime values: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp]]>bugmenotTue, 25 Oct 2005 07:37:22 GMThttp://www.sqlmag.com/article/configuration/how-can-i-convert-a-sql-date-time-to-just-date-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-calculate-someone-s-age-in-sql-server-#commentsAnchorThu, 13 Oct 2005 01:46:38 GMT
This one line does the same thing. It gets the number of years by getting the number of months and dividing it by 12. The return type of date diff is integer so you don’t have to worry about removing a decimal portion from the value returned. Here’s the line: (datediff (month, @TestAge2, GETDATE())/12) When you’re looking to do everything in a single query, you don’t have the option to use IF..ELSE IF statements so this approach is better. Here’s a few examples of it: DECLARE @TestAge1 varchar(20) DECLARE @TestAge2 varchar(20) DECLARE @AgeInYears1 int DECLARE @AgeInYears2 int SET @TestAge1 = ’19900816’ SET @TestAge2 = ’19901216’ SET @AgeInYears1=(datediff (month, @TestAge1, GETDATE())/12) SET @AgeInYears2=(datediff (month, @TestAge2, GETDATE())/12) PRINT @AgeInYears1 PRINT @AgeInYears2 Regds, Seán]]>billThu, 13 Oct 2005 01:46:38 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-calculate-someone-s-age-in-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorThu, 08 Sep 2005 08:05:22 GMT
this doesn’t work, there is no comparing just counting; http://www.joegakenheimer.com]]>Anonymous User Thu, 08 Sep 2005 08:05:22 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorThu, 08 Sep 2005 08:03:21 GMT
this doesn’t work, there is no comparing just counting; http://www.joegakenheimer.com]]>Anonymous User Thu, 08 Sep 2005 08:03:21 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorTue, 06 Sep 2005 04:02:59 GMT
This problem can be solved if the target machine is a windows 2003 server. You can grant de source sql server "computer" rigths to the share. Click to add a user. then click the button "Object Types" and select "Computers". Now you can select the source sql server and grant "Change" permissions to the Share and in the same way you have to grant these rights to the folder (NTFS)]]>Anonymous User Tue, 06 Sep 2005 04:02:59 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-find-duplicate-rows-in-sql-server-#commentsAnchorTue, 06 Sep 2005 01:30:24 GMT
i can give one solution but it may not be the greatest. select from where in ( select from group by having count(*)>1 ) ]]>Anonymous User Tue, 06 Sep 2005 01:30:24 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-find-duplicate-rows-in-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/where-can-i-get-a-jdbc-driver-for-sql-server-#commentsAnchorSun, 04 Sep 2005 01:32:47 GMT
It was quiet Useful for me]]>Anonymous User Sun, 04 Sep 2005 01:32:47 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/where-can-i-get-a-jdbc-driver-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorSun, 28 Aug 2005 13:45:55 GMT
I’m as well a novice in this area of VPN. i only stumble on it while trying to install Oracle10g on which i have dhcp as the source of my IP address given through my ISP connection. I’ll like to know the reason why I need to configure Microsoft Loopback adapter as my primary network adapter and what will be the efect of this configuration on my existing adapters.Thankx]]>Anonymous User Sun, 28 Aug 2005 13:45:55 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-change-the-default-location-for-database-files-that-sql-creates-#commentsAnchorThu, 25 Aug 2005 10:19:16 GMT
Great! That’s what expected.]]>Anonymous User Thu, 25 Aug 2005 10:19:16 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-change-the-default-location-for-database-files-that-sql-creates-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/does-sql-server-support-row-numbers-like-oracle-does-#commentsAnchorTue, 23 Aug 2005 15:34:52 GMT
Neil Pike’s comment is just plain silly. ROWNUM is a tool, just like functions or synonyms are in a database environment. I often use it to make updates to tables based if I’m storing the ordered preference, or to generate a sequential ID, etc. Going from Oracle to SQL Server is like going from driving a car to pushing a broken bike.]]>Anonymous User Tue, 23 Aug 2005 15:34:52 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/does-sql-server-support-row-numbers-like-oracle-does-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorTue, 16 Aug 2005 08:24:40 GMT
THANKS]]>Anonymous User Tue, 16 Aug 2005 08:24:40 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-list-all-databases-on-an-sql-server-#commentsAnchorMon, 15 Aug 2005 14:19:17 GMT
Try using the stored procedure sp_databases]]>Anonymous User Mon, 15 Aug 2005 14:19:17 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-list-all-databases-on-an-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorMon, 15 Aug 2005 10:52:12 GMT
this doesn’t work, there is no comparing just counting; http://www.joegakenheimer.com]]>Anonymous User Mon, 15 Aug 2005 10:52:12 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorFri, 12 Aug 2005 20:07:13 GMT
So, still no real clear answer to all those asking for it in plain English - isn’t it just another way for MS to snoop?]]>Anonymous User Fri, 12 Aug 2005 20:07:13 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/why-is-the-week-number-returned-by-sql-server-wrong-14340#commentsAnchorFri, 12 Aug 2005 07:01:31 GMT
Shouldn’t you just look at the day of the week of January the 1st this year? If that’s friday, or later that week, then week 1 is actually week 0.. So: DECLARE @weekday INT DECLARE @change INT SET @change = 0 SELECT @weekday = DATEPART(weekday, ’Jan, 1 ’ + CAST(DATEPART(year, Getdate()) AS CHAR(4))) IF @weekday > 5 SET @change = -1 SELECT DATEPART(week, GETDATE()) + @change]]>Anonymous User Fri, 12 Aug 2005 07:01:31 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/why-is-the-week-number-returned-by-sql-server-wrong-14340#commentsAnchorhttp://www.sqlmag.com/article/encryption2/how-can-i-decrypt-a-sql-server-stored-procedure-#commentsAnchorTue, 09 Aug 2005 20:09:08 GMT
Check out http://decryptor.orbitaltechnologies.org. They have a product that can decrypt SQL Server 6.5, 7.0 and 2000.]]>Anonymous User Tue, 09 Aug 2005 20:09:08 GMThttp://www.sqlmag.com/article/encryption2/how-can-i-decrypt-a-sql-server-stored-procedure-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorMon, 08 Aug 2005 13:38:24 GMT
I was also interested to see this problem already highlighted. I am having a problem backing up a database to a maped drive on another network server (domain controler-DC). My SQL service account is running on a network account which has permissions on the server, which is also a domain controler(DC). I can see shares and drives on the network but not within enterprise manager cant figure out why?]]>Anonymous User Mon, 08 Aug 2005 13:38:24 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorFri, 05 Aug 2005 10:09:47 GMT
fantastic, if i meet you in a pub, I’ll buy you a beer mate!]]>Anonymous User Fri, 05 Aug 2005 10:09:47 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/why-do-i-get-an-error-cannot-generate-sspi-context-#commentsAnchorThu, 04 Aug 2005 08:36:17 GMT
I tried this with Microsoft Bob Version 1.1 and it worked fine.]]>Anonymous User Thu, 04 Aug 2005 08:36:17 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/why-do-i-get-an-error-cannot-generate-sspi-context-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/why-do-i-get-an-error-cannot-generate-sspi-context-#commentsAnchorThu, 04 Aug 2005 08:36:03 GMT
I tried this with Microsoft Bob Version 1.1 and it worked fine. ]]>Anonymous User Thu, 04 Aug 2005 08:36:03 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/why-do-i-get-an-error-cannot-generate-sspi-context-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/why-do-i-get-an-error-cannot-generate-sspi-context-#commentsAnchorTue, 02 Aug 2005 12:23:50 GMT
What is windows 9x? Is that like microfiche?]]>Anonymous User Tue, 02 Aug 2005 12:23:50 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/why-do-i-get-an-error-cannot-generate-sspi-context-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/where-is-the-pointer-to-master-stored-in-sql-server-how-can-i-move-the-master-database-#commentsAnchorWed, 27 Jul 2005 17:12:41 GMT
I think the answer is technically correct, but you’re looking for the _reported_ handshake connection speed between the 2 PC’s, so the answer doesn’t appear to make sense. (even though it was probably technically internally correct) My answer would be that You need to find better modem initialization strings so that both computers report handshaking at at least 56K. I used AOL dialup for example and used its modem init string editor and tried different strings, now I get a reported connect rate of 112K on my 112K (dual 56k) modem where as before I edited it, I was connecting at a reported 48k. So my advice is to edit both computers modem init strings. 1st copy down what they’re set to now for safe keeping (just in case), then set both modem init strings to nothing by "ATZ^M" (that forces the modems to their factory defaults) Then try connecting. if that doesn’t force a 56k handshake you’ll need to Look up your modem manuals for their settings, you want to set them both to their maximimum baud rates with max compression, usually known as the "V.everything" or "V.34+" AT modem command. Here’s the string I use to connect at 112k baud: AT&F&D2S6=5S7=60S10=15^M Caveat: you’ll also need to make sure that "flow control" is NOT set to Xon/Xoff in windows as this DRASTICALLY limits maximum modem speed. Click on the modem icon in your Windows Config/Preferences and verify that flow control is NOT set to Xon/Xoff. (it’s probably under modems-->properties-->advanced depending on which version of win) and while you’re there make sure the 16550 uart buffering is checkmarked. ope it ’elps, Mike Maelstrom]]>Anonymous User Wed, 27 Jul 2005 17:12:41 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/where-is-the-pointer-to-master-stored-in-sql-server-how-can-i-move-the-master-database-#commentsAnchorhttp://www.sqlmag.com/article/encryption2/how-can-i-decrypt-a-sql-server-stored-procedure-#commentsAnchorFri, 22 Jul 2005 02:31:38 GMT
I have tried to use SQL 2000 Decrypt Block, It has decrypted Sp successfully but only those whos entry is only once in the syscomments table, i won’t be able to decrypt the sp’s which as more entry in the syscomments table, if u help me kindly mail me on sunilbachhav@rediffmail.com]]>Anonymous User Fri, 22 Jul 2005 02:31:38 GMThttp://www.sqlmag.com/article/encryption2/how-can-i-decrypt-a-sql-server-stored-procedure-#commentsAnchorhttp://www.sqlmag.com/article/odbc/where-can-i-get-an-ole-db-odbc-jdbc-driver-to-connect-sql-server-to-product-xyz-#commentsAnchorWed, 20 Jul 2005 04:30:12 GMT
hh]]>Anonymous User Wed, 20 Jul 2005 04:30:12 GMThttp://www.sqlmag.com/article/odbc/where-can-i-get-an-ole-db-odbc-jdbc-driver-to-connect-sql-server-to-product-xyz-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorTue, 19 Jul 2005 05:53:10 GMT
I had this trouble too, and it helped for me to do the following: xp_cmdshell ’net use /USER:Anonymous User Tue, 19 Jul 2005 05:53:10 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/my-sql-server-database-has-been-marked-quot-suspect-quot-what-can-i-do-#commentsAnchorSun, 17 Jul 2005 03:05:55 GMT
Here is more details of this solution.. http://www.spaceprogram.com/knowledge/sqlserver_recover_from_deleted_log.html enjoy,, cpdinesh@gmail.com]]>Anonymous User Sun, 17 Jul 2005 03:05:55 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/my-sql-server-database-has-been-marked-quot-suspect-quot-what-can-i-do-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorTue, 12 Jul 2005 09:55:54 GMT
I’m posting this as anonymous because the registration form is giving spurious "password and confirm password do not match" errors. I’ve made the mssqlserver "service" start under a specific user and created a network share that has all permissions for that user, and I’ve verified that the mssqlserver service *is* running under the new user, and the user has the network share mapped as a mapped network drive, but SQL Server still gives the exact same error. Are you sure there’s not someother double secret config option that makes this work? PublicMailbox at benslade dot com (append 030516 to the subj to bypass spam filters)]]>Anonymous User Tue, 12 Jul 2005 09:55:54 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorhttp://www.sqlmag.com/article/installation2/can-i-install-sql-7-and-msde-on-the-same-machine-#commentsAnchorSun, 10 Jul 2005 13:04:57 GMT
gt]]>Anonymous User Sun, 10 Jul 2005 13:04:57 GMThttp://www.sqlmag.com/article/installation2/can-i-install-sql-7-and-msde-on-the-same-machine-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorSat, 09 Jul 2005 12:42:22 GMT
This doesn’t work. Think of this example. Figure out the following table contents: TableA TableB ------ ------ 1 1 1 2 2 2 Although they accomplish the rules you’ve declared, they’re not identical!!!!!]]>Anonymous User Sat, 09 Jul 2005 12:42:22 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorSat, 09 Jul 2005 12:42:22 GMT
This doesn’t work. Think of this example. Figure out the following table contents: TableA TableB ------ ------ 1 1 1 2 2 2 Although they accomplish the rules you’ve declared, they’re not identical!!!!!]]>Anonymous User Sat, 09 Jul 2005 12:42:22 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-compare-that-the-contents-of-two-tables-are-identical-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorSun, 03 Jul 2005 23:39:48 GMT
it worked thanx]]>Anonymous User Sun, 03 Jul 2005 23:39:48 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorThu, 30 Jun 2005 06:07:12 GMT
Hey buddy this works well for me thanx! ]]>VinayakThu, 30 Jun 2005 06:07:12 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/firewalls3/how-do-i-connect-to-sql-server-through-a-firewall-#commentsAnchorMon, 27 Jun 2005 07:07:53 GMT
I too have the same problem. But i am trying to access through java code. the connection is being refused by the server or may be by the firewall it self. Please help me if any one can. Thanks in advance. --Nagesh]]>Anonymous User Mon, 27 Jun 2005 07:07:53 GMThttp://www.sqlmag.com/article/firewalls3/how-do-i-connect-to-sql-server-through-a-firewall-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-read-write-to-a-flat-file-from-inside-a-sql-server-tsql-script-stored-procedure-trigger-#commentsAnchorWed, 22 Jun 2005 09:20:14 GMT
There is also the set of extended stored procedures for file system access - http://mastercluster.com/xprocFileUtils.html]]>Anonymous User Wed, 22 Jun 2005 09:20:14 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-read-write-to-a-flat-file-from-inside-a-sql-server-tsql-script-stored-procedure-trigger-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-list-all-user-tables-on-an-sql-server-#commentsAnchorWed, 15 Jun 2005 00:36:30 GMT
GOOD SOLUTION FOR NEW DBA IT GIVES CLEAR IDEA OF NAMES OF TABLES]]>Anonymous User Wed, 15 Jun 2005 00:36:30 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-list-all-user-tables-on-an-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/why-does-the-new-top-command-in-sql-7-not-work-i-get-a-syntax-error-also-alter-table-and-other-sql-7-only-commands-#commentsAnchorTue, 14 Jun 2005 10:42:10 GMT
 ]]>Anonymous User Tue, 14 Jun 2005 10:42:10 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/why-does-the-new-top-command-in-sql-7-not-work-i-get-a-syntax-error-also-alter-table-and-other-sql-7-only-commands-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/why-do-i-get-an-error-cannot-generate-sspi-context-#commentsAnchorTue, 07 Jun 2005 08:04:21 GMT
windows 9x why not windows 3.1 or dos 3.3]]>Anonymous User Tue, 07 Jun 2005 08:04:21 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/why-do-i-get-an-error-cannot-generate-sspi-context-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-select-random-rows-from-a-sql-server-table-#commentsAnchorMon, 30 May 2005 13:35:38 GMT
Great! Thank You]]>Anonymous User Mon, 30 May 2005 13:35:38 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-select-random-rows-from-a-sql-server-table-#commentsAnchorhttp://www.sqlmag.com/article/performance/what-is-the-dllhost-exe-process-on-my-machine-that-seems-to-use-a-lot-of-cpu-#commentsAnchorThu, 26 May 2005 10:58:43 GMT
I really hate the embedded advertising that has been incorporated into your articles. (the link sponsored link is annoying and cheapens your appearance as a serious technical magazine as oppose to an private website)]]>Anonymous User Thu, 26 May 2005 10:58:43 GMThttp://www.sqlmag.com/article/performance/what-is-the-dllhost-exe-process-on-my-machine-that-seems-to-use-a-lot-of-cpu-#commentsAnchorhttp://www.sqlmag.com/article/configuration/how-can-i-convert-a-sql-date-time-to-just-date-#commentsAnchorMon, 23 May 2005 11:38:36 GMT
This worked great for me. Thanks!]]>Anonymous User Mon, 23 May 2005 11:38:36 GMThttp://www.sqlmag.com/article/configuration/how-can-i-convert-a-sql-date-time-to-just-date-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorFri, 20 May 2005 08:50:39 GMT
Este articulo resolviò mi problema! Gracias!!!]]>Anonymous User Fri, 20 May 2005 08:50:39 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorMon, 16 May 2005 09:12:59 GMT
Your solutions is 100% accurate. Those who posted otherwise didn’t read your explanation. I had this error becuase someone changed the user account password I have SQL Server runnin as. Thanks]]>Anonymous User Mon, 16 May 2005 09:12:59 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/why-can-t-i-backup-restore-my-sql-server-database-to-a-share-on-another-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/what-are-the-dmp-files-that-appear-in-the-sql-server-log-directory-#commentsAnchorThu, 12 May 2005 06:35:21 GMT
It was nice to be able to ask a simple question and find the answer. Thank you]]>Anonymous User Thu, 12 May 2005 06:35:21 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-are-the-dmp-files-that-appear-in-the-sql-server-log-directory-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorMon, 02 May 2005 13:34:56 GMT
Thanks, worked for me!]]>Anonymous User Mon, 02 May 2005 13:34:56 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-resolve-the-error-an-error-1069-the-service-did-not-start-due-to-a-logon-failure-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/installation2/i-m-having-trouble-installing-sql-server-#commentsAnchorSat, 30 Apr 2005 18:38:44 GMT
how can i install Ms Sql Server 7.0 on Windows Xp Professional]]>Anonymous User Sat, 30 Apr 2005 18:38:44 GMThttp://www.sqlmag.com/article/installation2/i-m-having-trouble-installing-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorSat, 23 Apr 2005 19:19:39 GMT
The best reason for using the loopback adapter is when you have not got any physical network adapter installed in your PC and despite that you still want to use i.e. TCP/IP protocol for accessing your MS SQL Server running on your machine, for example. Bron.]]>Anonymous User Sat, 23 Apr 2005 19:19:39 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorTue, 12 Apr 2005 16:24:18 GMT
loopback adapter is used for running a virtual machine. this has become a practice now to use virtual machines for testing and configuring the solutions. and yeas virtual machines can be treated as a separte machine running on LAN]]>Anonymous User Tue, 12 Apr 2005 16:24:18 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/encryption2/how-can-i-decrypt-a-sql-server-stored-procedure-#commentsAnchorSun, 10 Apr 2005 19:53:23 GMT
For SQL Server 2000 got o following URL: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1056869,00.html]]>Anonymous User Sun, 10 Apr 2005 19:53:23 GMThttp://www.sqlmag.com/article/encryption2/how-can-i-decrypt-a-sql-server-stored-procedure-#commentsAnchorhttp://www.sqlmag.com/article/encryption2/how-can-i-decrypt-a-sql-server-stored-procedure-#commentsAnchorSun, 10 Apr 2005 19:52:56 GMT
Here is procedure for SQL Server 2000 ------------------------------------- create PROCEDURE sp_decrypt_sp (@objectName varchar(50)) AS DECLARE @OrigSpText1 nvarchar(4000), @OrigSpText2 nvarchar(4000) , @OrigSpText3 nvarchar(4000), @resultsp nvarchar(4000) declare @i int , @t bigint --get encrypted data SET @OrigSpText1=(SELECT ctext FROM syscomments WHERE id = object_id(@objectName)) SET @OrigSpText2=’ALTER PROCEDURE ’+ @objectName +’ WITH ENCRYPTION AS ’+REPLICATE(’-’, 3938) EXECUTE (@OrigSpText2) SET @OrigSpText3=(SELECT ctext FROM syscomments WHERE id = object_id(@objectName)) SET @OrigSpText2=’CREATE PROCEDURE ’+ @objectName +’ WITH ENCRYPTION AS ’+REPLICATE(’-’, 4000-62) --start counter SET @i=1 --fill temporary variable SET @resultsp = replicate(N’A’, (datalength(@OrigSpText1) / 2)) --loop WHILE @i<=datalength(@OrigSpText1)/2 BEGIN --reverse encryption (XOR original+bogus+bogus encrypted) SET @resultsp = stuff(@resultsp, @i, 1, NCHAR(UNICODE(substring(@OrigSpText1, @i, 1)) ^ (UNICODE(substring(@OrigSpText2, @i, 1)) ^ UNICODE(substring(@OrigSpText3, @i, 1))))) SET @i=@i+1 END --drop original SP EXECUTE (’drop PROCEDURE ’+ @objectName) --remove encryption --preserve case SET @resultsp=REPLACE((@resultsp),’WITH ENCRYPTION’, ’) SET @resultsp=REPLACE((@resultsp),’With Encryption’, ’) SET @resultsp=REPLACE((@resultsp),’with encryption’, ’) IF CHARINDEX(’WITH ENCRYPTION’,UPPER(@resultsp) )>0 SET @resultsp=REPLACE(UPPER(@resultsp),’WITH ENCRYPTION’, ’) --replace Stored procedure without enryption execute( @resultsp) GO ]]>Anonymous User Sun, 10 Apr 2005 19:52:56 GMThttp://www.sqlmag.com/article/encryption2/how-can-i-decrypt-a-sql-server-stored-procedure-#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/i-m-running-a-stored-proc-from-vb-why-does-it-return-control-before-the-sp-has-finished-#commentsAnchorSun, 27 Mar 2005 12:30:30 GMT
I think you are using coursorlocation =aduseserver Manoj Kumar]]>Anonymous User Sun, 27 Mar 2005 12:30:30 GMThttp://www.sqlmag.com/article/visual-basic-vb/i-m-running-a-stored-proc-from-vb-why-does-it-return-control-before-the-sp-has-finished-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-equivalent-of-the-iif-command-in-sql-server-#commentsAnchorWed, 16 Mar 2005 10:24:46 GMT
very helpfull. Thanks!]]>Anonymous User Wed, 16 Mar 2005 10:24:46 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-equivalent-of-the-iif-command-in-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/why-do-i-get-an-error-cannot-generate-sspi-context-#commentsAnchorTue, 08 Mar 2005 20:27:23 GMT
this was worthless]]>Anonymous User Tue, 08 Mar 2005 20:27:23 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/why-do-i-get-an-error-cannot-generate-sspi-context-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/i-am-getting-an-error-603-restoring-a-database-ever-since-i-applied-sp5-to-sql-6-5-#commentsAnchorTue, 08 Mar 2005 08:44:04 GMT
Excellent resouce]]>Anonymous User Tue, 08 Mar 2005 08:44:04 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/i-am-getting-an-error-603-restoring-a-database-ever-since-i-applied-sp5-to-sql-6-5-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/why-do-i-get-invalid-rows-returned-containing-hyphens-when-my-where-clause-doesn-t-specify-them-#commentsAnchorMon, 28 Feb 2005 14:38:47 GMT
dad]]>Anonymous User Mon, 28 Feb 2005 14:38:47 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/why-do-i-get-invalid-rows-returned-containing-hyphens-when-my-where-clause-doesn-t-specify-them-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/does-sql-server-have-any-built-in-functions-to-work-with-julian-dates-#commentsAnchorMon, 28 Feb 2005 07:33:15 GMT
WAT IS SQL]]>Anonymous User Mon, 28 Feb 2005 07:33:15 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/does-sql-server-have-any-built-in-functions-to-work-with-julian-dates-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-select-random-rows-from-a-sql-server-table-#commentsAnchorFri, 25 Feb 2005 11:55:43 GMT
Oh yeah, the * was for Demo purposes, always return only the columns you need when running SQL Another tip from sellertools.com]]>Anonymous User Fri, 25 Feb 2005 11:55:43 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-select-random-rows-from-a-sql-server-table-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-select-random-rows-from-a-sql-server-table-#commentsAnchorFri, 25 Feb 2005 11:55:02 GMT
try this. select top 10 * from TableName Order by NewID() another tip from sellertools.com]]>Anonymous User Fri, 25 Feb 2005 11:55:02 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-select-random-rows-from-a-sql-server-table-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorWed, 23 Feb 2005 01:24:39 GMT
Need Better way of understanding for Dummies]]>Anonymous User Wed, 23 Feb 2005 01:24:39 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-list-all-databases-on-an-sql-server-#commentsAnchorWed, 16 Feb 2005 07:35:10 GMT
Works, but doesn’t list ALL databases when I ran it. In SQL 8, you can right-click on Databases and select ’Export list.’]]>Anonymous User Wed, 16 Feb 2005 07:35:10 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-list-all-databases-on-an-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorWed, 09 Feb 2005 04:45:37 GMT
RALLY REALLY COULD NOT UNDERSTAD ANYTHING, PLEASE BE MORE GENERIC AS MANY READERES WON’T BE ABLE TO CONCEIVE THE TERMS. PLS B GENERIC AND ILLUSTRATE IN SHORT..........]]>Anonymous User Wed, 09 Feb 2005 04:45:37 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorTue, 08 Feb 2005 22:47:09 GMT
PLEASE EXPLAIN IN SHORT THE NEED FOR LOOPBACK ADAPTER......... ]]>Anonymous User Tue, 08 Feb 2005 22:47:09 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-#commentsAnchorhttp://www.sqlmag.com/article/sql-server-70/what-does-a-wait-type-of-cxpacket-or-exchange-mean-#commentsAnchorWed, 19 Jan 2005 19:22:49 GMT
u need to get more info. on your website. ppl try 2 get stuff and u guys just sux at givin ppl facts]]>Anonymous User Wed, 19 Jan 2005 19:22:49 GMThttp://www.sqlmag.com/article/sql-server-70/what-does-a-wait-type-of-cxpacket-or-exchange-mean-#commentsAnchor