InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 03:35:10 GMT20http://www.sqlservercentral.com/Forums/Topic752906-146-1.aspxI can capture notifications fine on a the local instance but I want to be able for my services to be able to receive events from other servers. I've set up a service on another server a I can initiate a conversation and send a message but the event notifications will not send to a remote service.The event is set up with the SSB guid of the remote service.CREATE EVENT NOTIFICATION DDL_EVENTSON SERVERFOR DDL_EVENTS TO SERVICE 'NotifyService', 'f18c2c64-8810-40f8-9509-a9aada110c42' ;The route works. CREATE ROUTE NotifyRouteWITH SERVICE_NAME = 'NotifyService',BROKER_INSTANCE = 'f18c2c64-8810-40f8-9509-a9aada110c42',ADDRESS = 'TCP://SV0220SQLMON1:4022';I could send the notifications to the local queue and then message them off to the remote service but that seems like an extra step.Tue, 14 Jul 2009 11:47:55 GMTben.rosatohttp://www.sqlservercentral.com/Forums/Topic1454682-146-1.aspxHI at one of our client side a link server had been created 5 month back from sql server 2005 to sql server 2000.It was working fine.Even now when it right click on it and test connection it succeeds .But when i try to execute a quest which fetches data from sql server 2000 (using link server)i get following errorMsg 7399, Level 16, State 1, Line 1The OLE DB provider "SQLNCLI" for linked server "<Linked Server Name>" reported an error. The provider did not give any information about the error.Msg 7312, Level 16, State 1, Line 1Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked server "<Linked Server Name>". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema..Please tell me whats the issue.IS it related to rights and previliges or its anything else.Or any thing related to pwd.PLz reply fastThanks and RegardsAnoopMon, 20 May 2013 12:26:04 GMTanoop.mig29http://www.sqlservercentral.com/Forums/Topic1454739-146-1.aspxHi,I have this little query:[code="sql"]Select deddedcode, dedlongDesc, deddatetimecreated from dedcode where deddatetimecreated > DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), -1)[/code]I would like the results emailed to one person, but only if there are results (some days there won't be any new codes).What's the easiest way to accomplish this?It doesn't need to be a fancy report, plain text is fine.Mon, 20 May 2013 14:41:39 GMTkrypto69http://www.sqlservercentral.com/Forums/Topic1452450-146-1.aspxI've noticed that sysJobActivity shows a number of jobs where the stop_execution_date is NULL, but the run_requested_date is up to 3 years ago, so it looks like the job started 3 years ago and has not yet finished. If I look at these jobs in Redgate SQL Backup or in SQLSoft SQLjobvis then it looks like the jobs are just starting and ending on their usual schedules.I have 24 jobs in total like this, and it looks like the run_requested_date on them is in batches of around the same date/time per batch, so at first I though it might be something to do with the server being restarted and leaving jobs hanging, but the more recent ones were only 2 months ago and the server hasn't been restarted in over a year (it's a live/production server that is used 24/7).So my questions are: (1) What might have caused this? (2) Is it safe to just do an UPDATE on these records and change the stop_execution_date to something like '1900-01-01' (3) Are there any better ways to tidy this up?[b]EDIT:[/b] Source code to quickly see what I mean:[code="sql"]SELECT job.Name, job.job_ID, job.Originating_Server, activity.run_requested_Date, DATEDIFF(mi, activity.run_requested_Date, GETDATE()) as ElapsedFROM msdb.dbo.sysjobs_view job JOIN msdb.dbo.sysjobactivity activity ON job.job_id = activity.job_idWHERE activity.run_requested_date IS NOT NULL AND activity.stop_execution_date IS NULL --AND run_Requested_date >= '2013-01-01'ORDER BY 4[/code]Tue, 14 May 2013 03:30:15 GMTRoss.Mhttp://www.sqlservercentral.com/Forums/Topic1454698-146-1.aspxI came in after the weekend, and the following statement is failing with the error:"OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired".OLE DB provider "SQLNCLI" for linked server "(null)" returned message "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.".Msg 53, Level 16, State 1, Line 0Named Pipes Provider: Could not open a connection to SQL Server [53]. "SELECT *FROM OPENROWSET ( 'SQLOLEDB', 'Server=[servername];UID=xxxxxx;PWD=xxxxxxx;', 'SELECT * FROM dbname.dbo.branch') TabNameBut the statement below works fine, so I assume it's not a network issue.select * from [servername].dbname.dbo.branchAny suggestions as to what to look at?Mon, 20 May 2013 13:08:40 GMTJason Shadonixhttp://www.sqlservercentral.com/Forums/Topic1454639-146-1.aspxHi All,I am facing a couple of issues both after Configuring and before Configuring the Merge Replication.1) After Configuration :I have configure Merge Replication which includes all the Objects Tables,StoreProcedures,Views,Userdefined Function. Configuraion is successfull and data is in Syn.So far so good. Application team uses some triggers where the status of a column gets updates on successful completion of the task. Transaction will happen at bulkly.Replication is logging/syn for only 1st state(it has 4states).Is the problem with Replication configuration or the Trigger?2) Memory is largely consumed when a Snapshot agent is ran. It almost goes to 0 KB.My DB size is 3GB,Full Recovery Model,Available disk space is 17GB.Please suggest your answers.Thanks in Advance.Thanks,Vamsi.Mon, 20 May 2013 10:58:53 GMTvamsi2.khttp://www.sqlservercentral.com/Forums/Topic1449035-146-1.aspxI am running into issues with loading a UTF-8 flat file containing French characters using SSIS 2205 to a SQL 2005 database table. The french accents are lost after loading the file to SQL table. Can someone please help with the steps to follow ? Please see below steps followed 1. Flat file is in UTF-8 format. 2. SQL table (destination) data type is Nvarchar 3.Flat file connection is set to read file in 65001(UTF-8) and column is defined as Unicode string [DT_WSTR]4. collation is Latin1_General_CI_ASThe package runs OK , but the final results are missing the French characters.Thu, 02 May 2013 21:28:37 GMTaparna.t841http://www.sqlservercentral.com/Forums/Topic1060421-146-1.aspxI'm trying to add a user mapping to an already existing login. In the Login Properties for the login, I need to add another database, so I check it and enter the User and Default Schema. When I click OK, it gives me an error 15023 saying that the user already exists. It's supposed to already exist, I'm just adding a User Mapping to this login. Help?Tue, 08 Feb 2011 10:29:52 GMTRay Cacciatorehttp://www.sqlservercentral.com/Forums/Topic471503-146-1.aspxThe users within a particular domain group are having trouble accessing all the appropriate databases via their SQL Server Management Studio client. They receive the error message, “The database is not accessible. (Object Explorer).Am I lacking some permissions. All the related databases are in a Multi_User mode, Normal Status.I'm using SQL Server 2005 Mgmt Studio.Thanks in advance for all the fwd solutions.MathurWed, 19 Mar 2008 05:53:13 GMTAmbuj Mathurhttp://www.sqlservercentral.com/Forums/Topic1454313-146-1.aspxSeems like order of joins completely changes the execution plan. In my first query ,i am joining on a column at the end from first table, in my second query i am joining on a column first. Which one is preferred? Left join or Inner joins?[code="other"]SELECT R.PatientId, P.NameFROM Reg R INNER JOIN PatientInfo P ON R.Id = P.ID LEFT JOIN AccountDetails A ON P.AccountNumber = A.AccountNumber LEFT JOIN ChargeAudit C ON R.id = C.id---------------------------------------------------SELECT R.PatientId, P.NameFROM Reg R LEFT JOIN ChargeAudit C ON R.id = C.id INNER JOIN PatientInfo P ON R.Id = P.ID LEFT JOIN AccountDetails A ON P.AccountNumber = A.AccountNumber [/code]Sat, 18 May 2013 22:46:43 GMTcurious_sqldbahttp://www.sqlservercentral.com/Forums/Topic740896-146-1.aspxhi all,In my database i want to create new *.mdf file and i want to transfer selected tables frmo old mdf to new one.Is this possible?If yes how to create and how to move data from old mdf to new mdf?Thanks,NeeravWed, 24 Jun 2009 04:44:11 GMTNero-1119276http://www.sqlservercentral.com/Forums/Topic1453982-146-1.aspxWe were not able to start the sql server agent in SQL FAILOVER CLUSTER, getting the following error in the sqlagent.out 2011-11-03 12:15:15 - ! [298] SQLServer Error: 2, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001] 2011-11-03 12:15:15 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00] 2011-11-03 12:15:15 - ! [298] SQLServer Error: 2, A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. [SQLSTATE 08001] 2011-11-03 12:15:15 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start2011-11-03 12:15:21 - ! [298] SQLServer Error: 2, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001] 2011-11-03 12:15:21 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00] 2011-11-03 12:15:21 - ! [298] SQLServer Error: 2, A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. [SQLSTATE 08001] 2011-11-03 12:15:21 - ! [382] Logon to server '(local)' failed (DisableAgentXPs)2011-11-03 12:15:22 - ? [098] SQLServerAgent terminated (normally)Fri, 17 May 2013 06:59:35 GMTpradeep.k 50453http://www.sqlservercentral.com/Forums/Topic1450397-146-1.aspxI have a update statement which is killing my PLE( Page Life expectancy), it is dropping from 4000 to 120. Attached is the execution plan, would like to hear from other folks on how to optimize this.Tue, 07 May 2013 22:28:22 GMTcurious_sqldbahttp://www.sqlservercentral.com/Forums/Topic1453366-146-1.aspxHello All,We have sql 2005 32 bit servers with DB, jobs, reports, maintanence plans etc, now we have to migrate it to sql 2008 64 bit.Assuming all the DB names remain same withe different server names.1.DB - will back up restore will work?2. Jobs - will MSDB back up restore will work or job scripting?3. reports - will reports DB backup and restore will work along with Encryption keys backup restore?4. Maintanence Plans - will MSDB back up restore will work?5. what about space requirement will that be same?please provide your thoughts on this.Thu, 16 May 2013 02:30:40 GMTdurai nagarajanhttp://www.sqlservercentral.com/Forums/Topic1453381-146-1.aspxHi,One of the publication has few temp tables, which synchronises the data with subscriptions. I dont want this to happen. I mean I want to stop synchronizing data for few tables.Is there any way to do this?Thanks in advance,ShobhaThu, 16 May 2013 03:22:30 GMTshobha.aradhyahttp://www.sqlservercentral.com/Forums/Topic1214264-146-1.aspxI am getting below error when i try to restore database in sql server 2005SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.Any workaround?ThanksWed, 30 Nov 2011 14:45:47 GMTAdmingodhttp://www.sqlservercentral.com/Forums/Topic515417-146-1.aspxThis is an fyi (no response necessary).I got this error and researched it and found no good answer for how to deal with it:[font="Courier New"]"File ID 5 of database ID 8 cannot be shrunk as it is either being shrunk by another process or is empty"[/font]One post suggested that it was a memory issue, but it also suggested the only way to deal with it was to restart SQL. I don't have that luxury, so I cleared my cache and reran the shrink and the shrink worked. [font="Courier New"]DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE[/font]Thanks, DebWed, 11 Jun 2008 12:03:28 GMTDeb Andersonhttp://www.sqlservercentral.com/Forums/Topic1058481-146-1.aspxHi, I get the error msg "Procedure or function 'sp_MSforeachdb' expects parameter '@command1', which was not supplied."when i run the following: What am i doing wrong?EXEC sp_MSForeachdb 'USE [?]IF DB_ID(''?'') > 4BEGIN select table_name from [?].information_schema.tables where table_name = "table1"END'thanksThu, 03 Feb 2011 19:25:17 GMTramadesai108http://www.sqlservercentral.com/Forums/Topic1451566-146-1.aspxI'm using the FORFILES utility to delete files from folders older than 'X' days.[font="Courier New"]forfiles /p "i:\objectscripts" /s /m *.* /c "cmd /c del @path" /d -120[/font]I have it scheduled as a CmdExec type job on SQL 2005 (Server 2003). However, if there are no files to delete, the job fails with an error:"ERROR: No files found with the specified search criteria. Process Exit Code 1. The step failed."I'd rather not have the SQL job show as failed. Does anyone have an idea how to prevent failure ?Fri, 10 May 2013 07:01:29 GMThomebrew01http://www.sqlservercentral.com/Forums/Topic1450215-146-1.aspxThe issue I have is with the file retention of the .trn logs in my log shipping drive. 5 days worth of files are being retained. However, I have set the file retention in db properties / log shipping / backup settings to 3 days. Re-run backup, copy & restore jobs (which run every 15 mins anyway) & still 5 days worth of files are retained.I'm not sure which job (if any) is responsible for deletion of these files.I've repeated with a 1 day setting. No difference.I've checked the meta data. Backup_retention_period settings on primary & secondary servers = 1440 (24 hours), which is correct. Log shipping is up to date. The logs are not required. Permissions are fine (since files > 5 days are deleted). I need to cut this down as my drive is filling.Any ideas gratefully received.Thank you.Tue, 07 May 2013 09:21:49 GMTsnomadhttp://www.sqlservercentral.com/Forums/Topic1446349-146-1.aspxHi,We have an application which access data from SQL DB (SQL server 2005 std. edition). Around 40 members use the application @ the same time.Customer complains that they get below error message sometimes while connecting to the DB via the application"Database exception error:Query timeout expiredContact MTI Technical Support{RetCode=-1}State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0]SetPart.cpp(Line 663)Tue Nov 29 16:42:23 2011"As per the customer history with these application says if we do an index rebuild than the above error does not come.Same customer comes back every week with the same error. Question is why do customer get the above error while connecting to DB and how can an index rebuild operation avoid the error.Do we have any other solution to overcome the above error other than index rebuild?Thu, 25 Apr 2013 02:25:58 GMTsushantakumarpaulhttp://www.sqlservercentral.com/Forums/Topic1451885-146-1.aspxExperts,I have a query which is currently running.. Is there a way to find how much more time it will take to complete the execution ?Thanks in advance.Smith.Sun, 12 May 2013 02:00:27 GMTJoy Smith Sanhttp://www.sqlservercentral.com/Forums/Topic1451830-146-1.aspxHi all,I m using MS-SQL server 2005, and i want to schedule job on the interval of 15 days, as in the MS-SQL server scheduler No option present to schedule the job on the interval of 15 days.Could any one give there view on the same.Thanks in advance.Sat, 11 May 2013 08:08:01 GMTRRPAhttp://www.sqlservercentral.com/Forums/Topic1451695-146-1.aspxHi,I'm doing some DR testing. Is there a way I can disable all access to a Database, except for one specific user?My DB has 800 logins, and I want to disable all access during my DR testing, but during this testing my Report user account (one user) should be able to access the data (read only).Is there a script or a way to accomplish this? Fri, 10 May 2013 11:03:55 GMTkrypto69http://www.sqlservercentral.com/Forums/Topic1450452-146-1.aspxHi all,I have created several Maintenance Plans in the past - I now want to modify one of them .....So a simple right click on the selected plan and ..... nothing ... ziltch ... I can Execute and view history ... but not modify - it does appear in the list in a BOLD FONT.Any help would be appreciated.Wed, 08 May 2013 02:46:52 GMTSteveEClarkehttp://www.sqlservercentral.com/Forums/Topic1002377-146-1.aspxHiI have database mail setup and when I send an email via dbmail to myself for example, I see a BROKER_RECEIVE_WAITFOR in "ACTIVITY MONITOR". Status: SUSPENDEDDBName: msdbCommand: DELETEProgram Name: DatabaseMail90 <SomeMsgId>Is this a SQL issue of some kind or should I be concerned?thanks!Mon, 11 Oct 2010 12:03:08 GMTrew-370421http://www.sqlservercentral.com/Forums/Topic1450488-146-1.aspxI am trying to access data through linked server by following queryselect * from [Servername].dbname.schema.view_nameand my schema is not dbo.When I tried this with sa login it is giving me correct output,but when I tried to access data through login from which linked server is configured it is giving me login failed for user error.I have already maped database to login with it default schema.please help me out....Wed, 08 May 2013 04:39:32 GMTSQL Addicthttp://www.sqlservercentral.com/Forums/Topic348091-146-1.aspxConfiguration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.Next alert Only administrators may connect at this time. There is a chance some one messed with this but I cannot understand why.The person who was logged in at the time was running profiler and the logs confirm that the trace was stopped?What could trigger the change except user input.your input is as usual appreciated Mike Wed, 28 Feb 2007 06:10:00 GMTmngonghttp://www.sqlservercentral.com/Forums/Topic1449184-146-1.aspxI have a supplier who insists on having two jobs that every couple of hours change the Max Memory setting of the SQL Server instance. Basically one job sets the memory to 45Mb and the next back up to 46Mb each one running in turn every two hours. The supplier insists that without this "Memory Poke" some or all writes to the database start to take longer.I can see that every time the maximum memory setting is changed, the procedure cache is flushed out of memory, but I can't find anything that would suggest why regular changing of the max memory setting could influence database writes.Our monitoring software shows a Procedure Cache Hit Ratio of around 85% on average. A recent disabling of the jobs that change the memory setting didn't seem to push this higher.Anybody seen this elsewhere or got any suggestions as to where to look for an explanation; or even it can't have that effect? The supplier just wants it running "in case".Fri, 03 May 2013 07:13:53 GMTian.procterhttp://www.sqlservercentral.com/Forums/Topic1449422-146-1.aspxSomething about our production sql cluster is preventing the initial setup for Safenet encryption. The device sends sql to our prod cluster via jdbc driver. We know the sql arrives because we've captured it in profiler. The error returned is: microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result setThe sql sent to sql 2005 enterprise cluster from Safenet via jdbc driver, captured in profiler:[b]Note paramater @p1 is set to null but the following call to sp_cursorprepexec places “NULL” as a parameter instead of variable @p1[/b][u]Partial profiler capture:[/u]set quoted_identifier onset arithabort onset numeric_roundabort offset ansi_warnings onset ansi_padding onset ansi_nulls onset concat_null_yields_null onset cursor_close_on_commit offset implicit_transactions offset language us_englishset dateformat mdyset datefirst 7set transaction isolation level read committed set transaction isolation level read committed set implicit_transactions on declare @p1 int[b]set @p1=NULL[/b]declare @p2 intset @p2=0declare @p7 intset @p7=0exec sp_cursorprepexec @p1 output,@p2 output,NULL,N'declare @database varchar(128), @owner varchar(128), @exitStatus int set @exitStatus = 1 exec master.dbo.ing_get_metadata_info @database out, @owner out, @exitStatus out; select @database, @owner, @exitStatus ',16,8193,@p7 outputselect @p1, @p2, @p7NULLProd sql configurations that can be considered non-standard or at least not default.name run_value default_value Agent XPs 1 0 clr enabled 1 0 Database Mail XPs 1 0 fill factor (%) 90 0 max degree of parallelism 8 0 max server memory (MB) 356352 2147483647 min server memory (MB) 356352 0 Ole Automation Procedures 1 0 remote admin connections 1 0 show advanced options 1 0 user options 20856 0 xp_cmdshell 1 0 User options for my sql connection to prod cluster:21880ANSI_WARNINGSANSI_PADDINGANSI_NULLSARITHABORTQUOTED_IDENTIFIERANSI_NULL_DFLT_ONCONCAT_NULL_YIELDS_NULLXACT_ABORTSat, 04 May 2013 07:30:11 GMTIndianrockhttp://www.sqlservercentral.com/Forums/Topic973918-146-1.aspxHi All,I am trying to back up 6 Databases with the total of 108GB combined, all the databases are in simple recovery. I have tried to backup the databases on an external hard drive of 435GB but for the past 4 nights it hasn't been successful. When I have a look in the Job Activity Monitor the backup keeps saying it is executing but never backs up anything, it is also preventing the Truncate Transaction log backup from running which runs every half hour. I'm using the following script to run the backup:BACKUP DATABASE 'Databsename'TO DISK = 'E:\'filename'.BAK' Tue, 24 Aug 2010 02:45:30 GMTtt-615680http://www.sqlservercentral.com/Forums/Topic1450015-146-1.aspxHi AllEnvironment:Windows 2003 Enterprise Edition - 32bitSQL 2005 Standard Edition - 32BitPAE has been enabledServer has 16GB of ram installed and 8GB has been allocated to SQL ServerUsing task manager and sys.dm_os_sys_info - SQL is only using +-1.6GBFrom what I understand, AWE needs to be enabled now?Once AWE is enabled, should I see the amounts in task manager and sys.dm_os_sys_info increase to 8GB?Am I on the right track here?ThanksTue, 07 May 2013 01:49:17 GMTSQLSACThttp://www.sqlservercentral.com/Forums/Topic1449568-146-1.aspxIs it possible to Replicate from a Non-Partioned Table (Publisher- Standard edition) to a Partitioned Table (Subscriber- Enterprise edition) using Transactional Replication SQL SERVER 2005 (Pull Subscription) ? Will the Distribution agent detect the different schema on table level and does not allow the replication ? Sun, 05 May 2013 21:26:37 GMTstanley_1982http://www.sqlservercentral.com/Forums/Topic740655-146-1.aspxHi,Suppose you had a database stuck in single user mode that is in a busy OLTP environment.Given that:1. The connection that originally put the database into single user mode is gone.2. The DAC has not been set up on that instance.3. It is almost guaranteed that if you kill the spid holding the only connection to the database, another connection will grab it in milliseconds.How would you get the db back into multi-user mode?Thanks,AndyTue, 23 Jun 2009 17:19:12 GMTj.a.chttp://www.sqlservercentral.com/Forums/Topic482559-146-1.aspxHI,I am trying to attach few databases to sql server 2005.I have my .mdf files in "D:\MSSQL\Data" and my .ldf files in "E:\SQLLogs".when i try to attach it gives me below mentioned error------------------------------Unable to open the physical file "D:\MSSQL\Data\dbAcquisitionStaging_Data1.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476---------------------------I am added as administrator to this server. I checked for permissions on the .mdf and .ldf files It says full control.Could anybody please advise on how to fix this issue.This is hindering my progress. Any kind of help will be greatly appreciated.Thanks in advancelaysWed, 09 Apr 2008 12:46:40 GMTlays.babyblushhttp://www.sqlservercentral.com/Forums/Topic890300-146-1.aspxHello,When I click on properties of a database, users, tables, or any object within SQL Server Management Studio, I get this error:Cannot show requested dialog.Cannot open user default database. Login failed.Login failed for user 'PBTF\bob'. (Microsoft SQL Server, Error: 4064)I have set the default database to the master, by selecting Options on the Connect to Server dialog and ran this command: ALTER LOGIN 'PBTF\bob WITH DEFAULT_DATABASE = master.SQL Server says:Cannot alter the login 'PBTF\bob', because it does not exist or you do not have permission.'PBTF\bob' account is in a security group, which has been added to SQL Server for Server Access. 'PBTF\bob' and the security group are not added to the database security. Security group has admin rights in SQL Server.Despite all this, I still experience the error. Any tips on how I can fix this?ThanksThu, 25 Mar 2010 16:31:40 GMTpaulc.byrumhttp://www.sqlservercentral.com/Forums/Topic1447605-146-1.aspxHello All,I have MS SQL 2005/SP3 running on Windows 2003 standard. The server has 4GB and that is the maximum based on the OS. I am running SSIS as well as SQL server. Max memory is 3168 mb. I have SSIS packages that poll for files on a scheduled basis that can fail intermittently.I have also been seeing this in the SQL server logs.Error: 26050, Severity: 17, State: 1.Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ] due to a failure. Error: 0xe8, state: 4. The server will automatically attempt to re-establish listening.Server local connection provider has successfully re-established listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ].I am thinking of backing down max memory to 2500 mb on the theory that the OS/SSIS is a bit starved. Any thoughts?Mon, 29 Apr 2013 09:23:04 GMTChrissy321http://www.sqlservercentral.com/Forums/Topic1449138-146-1.aspxhi can we partition on last modified date thanks with best regardspradeepFri, 03 May 2013 05:24:25 GMTmpradeep23http://www.sqlservercentral.com/Forums/Topic1264782-146-1.aspxI get hundreds of these messages in my SQL Server logs every day (Exactly every 15 minutes).The messages have a sev 14 and a state 16, I have been searching the web for answers, but have drawn a blank thus far.One suggestion was to run a SQL Profiler trace.I did this and found that the ApplicationName is 'Microsoft Windows Script Host', but when I checked the Task Manager on the server, the ClientProcessID specified in the Profiler trace does not appear in the list of PIDs.I have also checked my Logins, and NT AUTHORITY\SYSTEM is present and enabled, and it has a server role of 'sysadmin', so I cannot see why the login would not be able to access any of the databases.Also, I have checked all Jobs to check any blank DB name (As a suggested solution) But I found nothing.Any help in tracking this down would be greatly appreciated.Sat, 10 Mar 2012 12:56:15 GMTstupid.brainhttp://www.sqlservercentral.com/Forums/Topic1448261-146-1.aspxIf I have SQL SERVER 2005 SP 4 @build 9.00.5296 dated October 24, 2011Will I be able to install Microsoft Security Bulletin MS12-070I see it isbuild 9.00.5069dated October 9, 2012 ?I see there is a build 9.00.5324 which I believe should have the security update but I cannot find a downloadable update. This only brings me to a 'description'.Does anyone know more about this?ThanksMarkTue, 30 Apr 2013 15:38:47 GMTganci.mark