Ms Sql Server Error 1038
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Error 1038 SQL Server > SQL Server SMO/DMO Question 0 Sign in to vote hi guys,when I try To create a SQL Server login that uses SQL Server Authentication (SQL Server Management Studio 2005 Express),error 1038 appears.It indictaes an error in transact language.How can I depass this thks for u help Wednesday, August 12, 2009 8:23 PM Reply | Quote Answers 0 Sign in to vote Hello,To try to help you more efficiently, could you provide some informations ?- are you creating your SQL Server login, are you using SMO or T-SQL statements or PowerShell ( only for SQL Server 2008 ) ?- could you provide your code ? ( replace your password by ****, security question )We are waiting for your feedback to try to help you more efficiently.Have a nice dayPS : for an explanation about the error 1038, please, could you have a look on this link ?http://msdn.microsoft.com/en-us/library/cc645860.aspx"An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name."i think you may have forgotten to provide an information ( login or password name for example ).Your code would be really useful Mark Post as helpful if it provides any help.Otherwise,leave it as it is. Edited by Papy NormandModerator Thursday, August 13, 2009 6:45 AM post-scriptum added Marked as answer by KJian_ Thursday, August 20, 2009 12:17 PM Thursday, August 13, 2009 6:32 AM Reply | Quote Moderator 0 Sign in to vote Hi Tunisien86,From your description, when creating a new login in SQL Server 2005 Management Studio Express, you got the following error, right? This error is not related to “SQL Server SMO/DMO”. choose name and passeword Like Papy said, we will receive this error wh
your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: Create login problem in SQL Server 2005 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-04-07,15:43 #1 Neomi View Profile https://social.msdn.microsoft.com/Forums/sqlserver/en-US/51f8f347-13af-4bcb-ab92-521b6672b86a/error-1038?forum=sqlsmoanddmo View Forum Posts Registered User Join Date Nov 2007 Posts 1 Unanswered: Create login problem in SQL Server 2005 Hey guys, I'm having a problem making a new login inside the sql management studio, the problem is, when i create a new login, i selected SQL Authentication, then type a password, then uncheck Enforce password policy. i then select the database i want the http://www.dbforums.com/showthread.php?1624027-Create-login-problem-in-SQL-Server-2005 login to be associated with, but once i click ok i get this exception: Create failed for Login ''. (Microsoft.SqlServer.Smo) An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) "An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or single space as the alias name. (Microsoft SQL Server, Error: 1038) I even tried with Northwind and a brand new database with a table and 2 columns but it's the same story every time. Any ideas? Thanks a bunch Reply With Quote 11-08-07,23:55 #2 anoopag View Profile View Forum Posts Registered User Join Date Nov 2007 Posts 1 Make sure you have entered "Login Name" in the text box provided at the top of the window thanks Anoop Reply With Quote Quick Navigation Microsoft SQL Server Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Data Access, M
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire https://www.experts-exchange.com/questions/20285083/Pull-replication-causing-error-1038-in-MS-SQL-Server.html for a Full Time Job Ways to Get Help Expand Search Submit http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44069 Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Pull replication causing error 1038 in MS-SQL Server. Want to Advertise Here? Solved Pull replication causing error 1038 in MS-SQL Server. Posted on 2002-04-04 MS SQL Server 1 ms sql Verified Solution 5 Comments 1,594 Views Last Modified: 2007-11-27 I am attempting to set up a simple snapshot replication between two SQL 2000 servers. I have set a machine up to do a pull replication from another machine. The setup process seemed to work fine, and the publishing machine reports that it has generated the initial snapshot. As well, the initial schema was ms sql server created on the target machine in a new database set up to receive the snapshot. However, on the pull side I am receiving the following error from the pull replication scheduled process itself (several tables and stored procedures do get transferred prior, but the error does not specify which object failed to transfer). The error is as follows: Category:SQLSERVER Source: BATTRA Number: 1038 Message: Cannot use empty object or column names. Use a single space if necessary. I have searched the MS online docs and support DB's, as well as Googling for this message, but I have found nothing useful to help me diagnose the cause, simply others asking similar questions in other forums. 0 Question by:Godeke Facebook Twitter LinkedIn Google Best Solution bymodulo PAQ'd and points refunded modulo Community Support Moderator Experts Exchange Go to Solution 5 Comments LVL 2 Overall: Level 2 MS SQL Server 1 Message Expert Comment by:UncleMatt2002-04-05 you'll probavbly have to trawl through your tables looking for a field without a fieldname, it won't be fun if it's a big database. you might be able to look in the syscolumns
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums Transact-SQL (2000) Error Msg: 1038 Reply to Topic Printer Friendly Author Topic sathyav Starting Member India 27 Posts Posted-12/28/2004: 06:55:08 Hi all,SET @RESULT = ( SELECT nullif(LEFT(FIRSTNAME, 3),'') FROM STUDENT WHERE rollno = @ROLL)When i use the above query in a SP, I get the following error msg,Error Description : [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot use empty object or column names. Use a single space if necessary.pls clarify me if i could use Nullif function in the columnlist of a select queryWith thanks and regardsSathya Kristen Test United Kingdom 22859 Posts Posted-12/28/2004: 13:14:49 Is that the exact SQL from your application? It isn't using double quotes is it?SELECT nullif(LEFT(FIRSTNAME, 3),'')will return NULL if the first three characters of FIRSTNAME is ... ermmmm ... "an empty string" - is that what you mean?Kristen Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server Administration (2005) .NET Inside SQL Server (2005) SSIS and Import/Export (2005) Service Broker (2005) Replication (