I can't find this anywhere in the thousands of objects in SSIS. So I thought I would ask.
I have a situtation where I want to retrieve the serverinstance name of the SSIS job is running on. I have multiple servers and instances and I want to send emails like "Failed see serverinstance - job name".
Any ideas?
Thanks
Hi, what is the different when I execute
select count(*) from [servernameinstance].database1.dbo.tablename(nolock)
and
select count(*) from database1.dbo.tablename (nolock)
for the first code, I will get error
Msg 4122, Level 16, State 1, Line 1
Remote table-valued function calls are not allowed.
How can I use nolock with sever name and instance specified in the select statement??
Hi groupI want to make a new serverinstance, but based on some old files from aprevious instance I once had from a SQL I scrapped.I only know how to use the SQL Server enterprise manager console, and Ihaven't found any tools in there to do that.Any suggestion will be more than welcome.Adrian
View 1 Replies View RelatedI am working on setting up our new SQL Server 2005 servers. One ofthem will eventually be our Replication Distributor. However when Iattempt to set this up within the wizard, I get the following error:------------------------------TITLE: New Publication Wizard------------------------------SQL Server could not configure 'ServerInstance' as a Distributor.------------------------------ADDITIONAL INFORMATION:Property LoginSecure cannot be changed or read after a connectionstring has been set. (Microsoft.SqlServer.ConnectionInfo)------------------------------BUTTONS: OK------------------------------In the "Specify the Domain or Machine account under which the Snap ShotAgent will run" page, I designate a Windows Auth. domain user; The sameuser that is used to start SQL Service. Any idea as to why I amgetting this error?
View 1 Replies View RelatedI'm trying to figure out how to set up SQL Express so I can start learning SQL. I've installed SQL Express, but when I type "sqlcmd -S ServerSQLExpress," I receive the following error:Microsoft Windows XP [Version 5.1.2600](C) Copyright 1985-2001 Microsoft Corp.C:Documents and SettingsUsername>sqlcmd -S ServerSQLExpressHResult 0xFFFFFFFF, Level 16, State 1SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
View 9 Replies View Related