Monday, June 3, 2013

[SQL Server 2008 issues] Import Export Wizard Performance

[SQL Server 2008 issues] Import Export Wizard Performance

Import Export Wizard Performance

Posted: 02 Jun 2013 05:58 PM PDT

I am having access to sql server 2005.Question : I need to load a text file data to the sql server table.Which of the following options will be better?1.Use BIDS,Import & Export Wizard,use source as text file and load it into sql server table.2. Use BIDS,Import & Export Wizard,use source as XML file and load it into sql server table.3. Use SSMS,Import & Export Wizard,use source as text file and load it into sql server table.4. Use SSMS,Import & Export Wizard,use source as XML file and load it into sql server table.

Connectivity issue

Posted: 02 Jun 2013 12:52 PM PDT

Hi,I am trying to connect to a named instance on another server myhost\myinstance, but get an error message:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476If I use IP address and the port number, it all works fine. I can even connect using the hostname and the port number, but if I use the instance name, it does not work.E.g.:xxx.xxx.xxx.xxx,3000 -- worksmyhost,3000 -- worksmyhost\myinstance -- does not workI can connect to myhost\myinstance from another server just fine.The server which has problem is a clustered instance of SQL 2008 R2 SP2, the two other servers are SQL 2008 R2 SP1.Any ideas?Thanks.

How to reduce the size of the t-log file of a mirrored DB that is still in restoring mode

Posted: 02 Jun 2013 12:50 PM PDT

Hello gentsThis might look like an oddball question, but one mirrored DB on our DR box has a huge t-log file that is occupying way too much space and my boss is asking me to reduce it.Has anyone encountered the same kind of situations before? I am a bit reluctant to shrink the PROD side ( hopefully and theoretically the t-log shrink action will be propagated to the DR?). And way to accomplish this purely on DR?Thanks in advance for any inputs!

SSRS Plug-ins

Posted: 02 Jun 2013 06:28 PM PDT

Hi, I have users who want to graphically create their own SQL Reports (in R2 and 2012) . We have setup a set of standard SQL reports for them however specific users have been asking for a graphical interface (drag n drop) so they can create their own reports using the SSRS engine. Can anyone help with recommendations of front-ends that I can install so semi-skilled users can create their own reports ralatively easily? This can be either open source or cheap applications to purchase.ThanksPete

Error

Posted: 03 Dec 2011 12:45 AM PST

I am getting while using database. I was trying to take databse in OFFLine.Msg 952, Level 16, State 1, Line 1Database abc is in transition. Try the statement later.

SQL server Query

Posted: 02 Jun 2013 06:26 PM PDT

PLease tell me what is the Query Recasting

How to Desc the memory Pressure in SSIS

Posted: 02 Jun 2013 06:04 PM PDT

How to Desc the memory Pressure in SSIS ?1.Set the diff buffer max=02.Reduce the engine threads3.Increase BLOB temp storage4.Reduce buffer size

Gmail Setup For SMTP

Posted: 02 Jun 2013 04:56 PM PDT

Hi,I am set Gmail For SMTPin mssql.Configuration had been done. But While sending Mail.It is showing Error "530.5.5.1 Must issue a STARTTLS Command first "Any have solution??Thank in Advance.

SSRS - reports rendering incorrectly

Posted: 02 Jun 2013 05:16 PM PDT

Hi allI am currently having this problem on SSRS rending incorrectly.The problem is basicall that reports do not display correctly in Chrome, Firefox, Safari browsers etc – the IFRAME's height defaults to a few hundred pixels, so you only see the top 2 inches of the report. There are artlices which suggest changes to the ReportViewer.aspx file found under SSRS directory. I am not confortable making changes to SQL system files, but if it has to get done, then so be it. Other than making a change to this file, is there any other options i can look at?thanks all for inputs!!!

How to rollback an insert query on sql server ? , please suggest bit high priority .. thanks in advance

Posted: 02 Jun 2013 01:28 AM PDT

How to rollback an insert query on sql server ? , please suggest bit high priority .. thanks in advance

Location and name of SQL Server 2008 R2 for Connection String

Posted: 01 Jun 2013 11:21 PM PDT

I have SQL Server 2008 R2.I need the location and name of SQL Server 2008 R2 to put into my connection string.

Agent Job Links to Another SQL Server and Fails due to Service Account Privs

Posted: 22 May 2013 02:54 PM PDT

To my friends in the community, here is a stumper that I can't seem to find sufficient information on despite repeated Google searches to figure out how to solve. Let me preface my explanation by saying that I am not a DBA and I have only limited access to the involved servers because they belong to a customer for which we are implementing an application.What is going to be needed is kind of a step-by-step, cookbook approach because I'm not sure at quite what level their DBA resources operate. Without further adieu:1. Our application runs on a virtualized server named SQL2. I do not have direct access to this server but I can access the database for our application using SSMS from the application tier's server.2. There is a SQL Server Agent job defined that runs on SQL2 but links to a different SQL Server (SQL1) containing another application from which our application needs to draw some data. I do have limited access directly to SQL1 but very limited privileges there.3. On both servers, there is a SQL account defined ('myaccount') and the password is the same on both. This account does have sufficient privs on SQL1 to access the customer's application's database, or at least the table I need to read from.On my application server, I can launch SSMS, connect to SQL2 and run the SP below and it runs just fine. It is but a small subset of the actual SP that needs to run to keep this somewhat simple. I have defined an agent job on SQL2 whose owner is 'myaccount.' When the agent job runs it gets an error message. It is set up to run the exact same EXEC as shown below.[code="sql"]-- From SSMS this runs without issues:EXEC [dbo].[TestConnectToLinkedServer];-- Above is defined as the job step in the agent job named "Test Linked Server Connection"-- When I run this, it failsEXEC msdb..sp_start_job N'Test Linked Server Connection';-- I can get the error message it fails on with this (top 2 rows):EXEC dbo.sp_help_jobhistory @job_name = N'Test Linked Server Connection',@mode='FULL' ;[/code]The error message returned by the last query is:[code="plain"]The job failed. The Job was invoked by User myaccount. The last step to run was step 1 (Run SP).Executed as user: NT AUTHORITY\SYSTEM. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [SQLSTATE 28000] (Error 18456). The step failed.[/code]Clearly the account that is being used on SQL1 (AUTHORITY\ANONYMOUS LOGON) isn't the same as the one on SQL2 (NT AUTHORITY\SYSTEM). I'm thinking this must have something to do with the account mappings but I am not sure on which server the mapping needs to be changed (or for that matter what it needs to be changed to).Here is the SP that is run either manually or by the agent:[code="sql"]CREATE PROCEDURE [dbo].[TestConnectToLinkedServer]AS BEGIN DECLARE @CustAppDBname NVARCHAR(20) = N'CustApp' ,@LinkedServer NVARCHAR(20) = N'SQL1' ,@retval INT ,@ErrorCount INT = 0 ,@ErrorCount1 INT = 0 ,@SQL NVARCHAR(MAX); IF NOT EXISTS ( SELECT 1 FROM sys.servers WHERE name = @LinkedServer) EXEC sp_addlinkedserver @server=@LinkedServer, @srvproduct=N'SQL Server'; BEGIN TRY -- This will fail if there is no server to link to (i.e., account not recognized) EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=@LinkedServer ,@useself='TRUE', @locallogin='myaccount'; SELECT @retval = 0; END TRY BEGIN CATCH SELECT -3, 'Problem linking to Customer'' app server: ' + @LinkedServer, @retval ,[SQL Error Number] = ERROR_NUMBER() ,[SQL Error Severity] = ERROR_SEVERITY() ,[SQL Error State] = ERROR_STATE() ,[SQL Error Procedure] = ERROR_PROCEDURE() ,[SQL Error Line] = ERROR_LINE() ,[SQL Error Message] = ERROR_MESSAGE();; SELECT @ErrorCount = @ErrorCount + 1, @retval = -1; SELECT @ErrorCount1 = -3 END CATCH IF @ErrorCount = 0 EXEC @retval = sys.sp_testlinkedserver @LinkedServer; IF @retval <> 0 BEGIN SELECT -4, 'Test of linked server failed' SELECT @ErrorCount = @ErrorCount + 1, @retval = -1; END SELECT @SQL = N' SELECT TOP 10 * FROM [' + @LinkedServer + N'].[' + @CustAppDBname + N'].dbo.AppTable' EXEC sp_executesql @SQL IF @LinkedServer IS NOT NULL AND EXISTS ( SELECT 1 FROM sys.servers WHERE name = @LinkedServer) BEGIN IF @ErrorCount1 <> -3 EXEC sp_droplinkedsrvlogin @rmtsrvname=@LinkedServer, @locallogin='myaccount'; EXEC sp_dropserver @LinkedServer, 'droplogins'; ENDEND[/code]Any help would be greatly appreciated. BTW. I am not sure there's sufficient information here to lead someone to identify and precisely resolve the issue. If there is not, please let me know what additional information you need to diagnose the issue and I'll try to get it. It may take a day or two to get it as I'll be relying on others arms and legs to get it done (most likely).

help needed urgently with datediff query

Posted: 01 Jun 2013 09:03 PM PDT

Hi - I have been trying to return the date diff value and keep getting an error saying:character constant must contain exactly one characterThis is what I am currently trying - can anyone let me know what I am doing wrong please? any help appreciated...return Convert.ToDecimal(microsoft.visualbasic.DateDiff(microsoft.visualbasic.DateInterval.Day, Date.Parse("[CUST_Tickets.CREATE_DATE)"), microsoft.visualbasic.Now))Julie
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog