http://www.sqlmag.com/authors/author/author/5101372/rsscomment/5101372en-USFri, 25 May 2012 10:48:42 GMTFri, 25 May 2012 10:48:42 GMThttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorFri, 10 Feb 2006 17:49:27 GMT
This script saved me a couple of hours of work! Excellent.]]>JACOBFri, 10 Feb 2006 17:49:27 GMThttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorhttp://www.sqlmag.com/article/quering/identify-the-identity#commentsAnchorSun, 22 Jan 2006 23:13:53 GMT
Hi, Please Guide me for the following issue,While executing the following code it is showing some warnings that ’ (141 row(s) affected) (141 row(s) affected) Warning: The table ’processed_olap_data_1’ has been created but its maximum row size (3873071) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes’. so is the any other to add the identity column to a table with out warnings....? Please suggest me..... The Code is as following ------------------------- IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(’[DBO].[processed_olap_data_1]’) AND OBJECTPROPERTY(ID, N’ISUSERTABLE’) = 1) DROP TABLE [DBO].[processed_olap_data_1] select * into dbo.processed_olap_data_1 from pubs.dbo.processed_olap_data_1 EXEC (’ALTER TABLE dbo.processed_olap_data_1 ADD generatedid INT IDENTITY’) Thanks, Rao Aregaddan.]]>Narasimha RaoSun, 22 Jan 2006 23:13:53 GMThttp://www.sqlmag.com/article/quering/identify-the-identity#commentsAnchorhttp://www.sqlmag.com/article/quering/identify-the-identity#commentsAnchorWed, 03 Aug 2005 02:11:54 GMT
Grateful for the info. I needed a way to detect tables with IDENTITY columns and found this most useful. Thanks for introducing me to the OBJECTPROPERTY function as well.]]>Anonymous User Wed, 03 Aug 2005 02:11:54 GMThttp://www.sqlmag.com/article/quering/identify-the-identity#commentsAnchorhttp://www.sqlmag.com/article/quering/identify-the-identity#commentsAnchorTue, 21 Jun 2005 00:41:59 GMT
right on]]>Anonymous User Tue, 21 Jun 2005 00:41:59 GMThttp://www.sqlmag.com/article/quering/identify-the-identity#commentsAnchorhttp://www.sqlmag.com/article/tsql3/capture-that-data#commentsAnchorThu, 22 Jul 2004 09:55:18 GMT
This is very good. Do you know if it will work for DBCC PAGE as well? Thanks Jamie]]>SungardThu, 22 Jul 2004 09:55:18 GMThttp://www.sqlmag.com/article/tsql3/capture-that-data#commentsAnchorhttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorMon, 14 Jun 2004 12:52:00 GMT
Very cool. I like it.]]>Stepan Kudryashov Mon, 14 Jun 2004 12:52:00 GMThttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorhttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorTue, 04 May 2004 14:28:10 GMT
Didn’t work out for me. Failed to transfer passwords correctly. Probably varbinary(256) isn’t the way to go.]]>oscarTue, 04 May 2004 14:28:10 GMThttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorhttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorWed, 07 Apr 2004 08:07:58 GMT
hi all, With respect to the previous email (Bug in syslogins) For example run this query in QA with Results in grid: select char(1) pwd,1 as col1,2 as col2 I task that must create the new view syslogins with the column password in last. Thanks]]>kroll_SQLWed, 07 Apr 2004 08:07:58 GMThttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorhttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorWed, 07 Apr 2004 08:07:58 GMT
hi all, With respect to the previous email (Bug in syslogins) For example run this query in QA with Results in grid: select char(1) pwd,1 as col1,2 as col2 I task that must create the new view syslogins with the column password in last. Thanks]]>kroll_SQLWed, 07 Apr 2004 08:07:58 GMThttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorhttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorWed, 07 Apr 2004 03:26:11 GMT
hi all, You explain me in order which reason changing the position of the column password the column isntname gives back various values? thanks --Query 1 select * from ( select language = convert(sysname, language), hasaccess = convert(int, CASE WHEN (xstatus&2)=2 THEN 1 ELSE 0 END), isntname = convert(int,case when (xstatus&4) = 4 then 1 else 0 end), password = convert(sysname, password) from sysxlogins a where srvid is null ) x --Query 2 select * from ( select password = convert(sysname, password), language = convert(sysname, language), hasaccess = convert(int, CASE WHEN (xstatus&2)=2 THEN 1 ELSE 0 END), isntname = convert(int,case when (xstatus&4) = 4 then 1 else 0 end) from sysxlogins a where srvid is null ) x]]>micheleWed, 07 Apr 2004 03:26:11 GMThttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorhttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorWed, 03 Mar 2004 02:20:01 GMT
Very helpfull: Thanks]]>JacquesWed, 03 Mar 2004 02:20:01 GMThttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorhttp://www.sqlmag.com/article/quering/reader-challenge7845#commentsAnchorThu, 17 Jan 2002 12:03:31 GMT
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q186265 Use DATEPART() function instead (see above link)]]>Rene Radhay Thu, 17 Jan 2002 12:03:31 GMThttp://www.sqlmag.com/article/quering/reader-challenge7845#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/reader-challenge-unencrypted-information#commentsAnchorFri, 05 Oct 2001 08:16:45 GMT
Great solution! I implemented this solution on my test server and everything works great except my backup jobs that I used sqlmaint.ext to create don’t work anymore. It appears that it needs to use named pipes to run the backup jobs. Any ideas on how I can tell it to use the "renamed" named pipes in order for it to work???? Thanks for any light you can shed on this for me!]]>DorothyFri, 05 Oct 2001 08:16:45 GMThttp://www.sqlmag.com/article/systems-administrator/reader-challenge-unencrypted-information#commentsAnchorhttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorTue, 31 Jul 2001 14:59:45 GMT
Hello. I had a question regarding this article. I would like to take this one step farther. How do you also copy database access roles for users. For example, you can use this method to change the domain name for a user account, but how can you get the access roles to that database? Thanks!]]>James J Maumus Tue, 31 Jul 2001 14:59:45 GMThttp://www.sqlmag.com/article/query-analyser/sql-server-login-transfer#commentsAnchorhttp://www.sqlmag.com/article/quering/reader-challenge7845#commentsAnchorWed, 07 Mar 2001 16:37:42 GMT
Instead of 112, he should try the style code 23 to get the "pure" date and 24 for the time.]]>Alex Lazar Wed, 07 Mar 2001 16:37:42 GMThttp://www.sqlmag.com/article/quering/reader-challenge7845#commentsAnchor