Answer Questions

• Yelnik Windows Services for SQL Server 2000

  For a SQL Server 2000 machine that performs no other function than being a database server with no web services, reporting services, or analysis services, I'm wondering if there is any documentation on what services would typically be running and, more importantly, which ones could be stopped. For example, I'm looking at a server and I see services such as Computer Browser and Microsoft Search. I don't see why either of these services are necessary for this machine. Thank you Microsoft Search is necessary if you are using Full-text search. Otherwise you can stop. Computer Browser is a Windows component -- this link will give you information on the service: http://support.microsoft.com/kb/188001 ...Show All

• Barista How to debug a script component task???

  Hi all of you, How to debug a script component task made in .Net I've got a Inmediate Window, Start Without Debugging, Toggle Breakpoint, etc but nothing works. When I press Start nothing happens. I suppose that anything very very of paramount importance I'm forgetting but I haven't any clue TIA You cannot debug the stock script component, only the task allows this. For custom components you wrote from scratch you attach the debugger to DtsDebugHost.exe, to debug packages running in BIDS. I actually prefer setting the Project properties debug options. Point it to dtexec and give it some parameters to load a packge. Then just run. Saves the manual attach if you are doing a lot of runtime debugging. So it's useless al ...Show All

• ssmorgan Deletes on subscriber in merge replication

  Using Merge replication between SQL Server 2000 and SQL Server CE, is there any way that row deletes could occur on the subscriber without a reinitialize or explicit delete of row on publisher. More specifically, if there is a row filter that returns a days worth of data with each days pull, for example, and the filter looked like select <columns> from Table where UpdateDate < GETDATE() and UpdateDate >= DATEADD(d,1,GETDATE()) would there be some implicit delete at subscriber each day because data sent changed My research indicates this does not happen, but I have a colleague who thinks differently. Thanks for the clarification. I have been able to convince myself that deletes occur on ...Show All

• Milzit Analysis Services and Proclarity

  We have following environment setup: SQL Server 2005, SSAS 2005 and Proclarity working together to provide some business intelligence. I have login problems with Proclarity Dashboar server. What happens is after user logs in into the dashboard server and leaves the browser (IE6) idle for some period of time, the user gets logged out (due to session time out). Once logged out, the user can't log back in as themselves. Now if the user logins with some other userid and logs out properly, then he/she can log back in again as themselves. Dashboard uses the windows userid/password for logins. Anybodys help would be greatly appriciated. Thanks Giri Looks like you are us ...Show All

• toniSQL sql:field from an attribute reference in XML?

  Looking for some hints about an XSD format that would translate the XML below back into a table: <Column INDEX= "0">ColA_Name</Column> <Column INDEX = "1">ColB_Name</Column> <Row> <Cell INDEX = "0">DataA1</Cell> <Cell INDEX = "1">DataB1</Cell> </Row> <Row> <Cell Index = "0">DataA2</Cell> <Cell Index = "1" >DataB2</Cell> This represents the table: ColA_Name ColB_Name DataA1 DataB1 DataA2 DataB2 The key here seems to be getting the "INDEX" attribute recognized as a reference, but I haven't had any luck e ...Show All

• Frank Racis views & outer joins

  I'm having problems with queries that use a view in an outer join. It's just sits there and grinds. Below is some queries to illustrate. SELECT EvalID,RecIndex FROM dbo.vCurrentEvalInfo Executed in 1 second in SQL Query Analyzer Returns 29,820 Rows ---- SELECT RecIndex FROM dbo.tblCNAKeyInformation Executed in 1 second in SQL Query Analyzer Returns 47,978 Rows ---- SELECT C.RecIndex, E.EvalID FROM dbo.tblCNAKeyInformation C LEFT OUTER JOIN dbo.vCurrentEvalInfo E ON C.RecIndex=E.RecIndex Executed in 1 second in SQL Query Analyzer Returns 47,978 Rows ---- SELECT C.RecIndex, E.EvalID, E.DATE_COMP, E.EvalDate, E.EvalCode, E.EvalResults FROM dbo.tblCNAKeyInformation C LEFT OUTER JOIN dbo.vCurrentEvalInfo E ON C.RecIndex=E ...Show All

• GertB SQL Server agent

  I have all sql services running under a sqlservice domain account that is local admin of the server. The sql agent service though keeps giving me a message saying WMI Provider error: no mapping between account names and security ID's was done" . This is the only service that is giving me a problem using this account. I deleted the account and recreated it, and still same. it's a part of built in administrators which is already a sysadmin in sql. any ideas Sounds like an Orpahned SID, have you tried explicitly adding your service account into SQL Server with Sysadmin permissions     yes sir. also, the id was never deleted. i d ...Show All

• Christian Sciberras sys.sp_testlinkedserver

  According to BOL extended stored procedure sys.sp_testlinkedserver returns 0 on successfully connecting to linked server and 1 when it fails. But I tried this Created a linked server to default instance of 2000 called TEST and used following script to test the extended stored procedure and instead of printing my PRINT statement it generated error -- CHECK LINKED SERVER CONNECTION DECLARE @ServerName sysname DECLARE @a int SET @ServerName = 'TEST' IF EXISTS( SELECT 1 FROM master . dbo . sysservers WHERE srvname LIKE @ServerName ) BEGIN EXEC @a = sys.sp_testlinkedserver @servername = @ServerName IF @a = 0 print 'LINKED SERVER ''' + ISNULL ( @ServerName , '' ) + ''' IS CONNECTED.' ...Show All

• Ben Taylor access to remote server for developers works ,but they can't create folder or add new package to msdb

  Hi , on test server I added developers domain group and DBA group to dcom using article http://sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx and made developers domain group dbo of msdb on test server developers can connect to remote test server ,see SSIS ,browse between folders but when they trying to create new folder in msdb they get error saying ... folder already exist when they trying to import new SSIS to msdb they get get error saying ...access to package denied Remote access (import/export ,new folders creation) fully work only for DBA group ...Show All

• Hopoz Creating a Database

  Hi. Im brand new to using SQL. I downloaded the SQL Server 2005 Trial Edition (Enterprise Evaluation Edition) and installed it. How do i create a database The only thing i can seem to open is the SQL Server Configuration Manager which just lets me start the Server. Did I install it wrong or open the wrong program If someone could help I would greatly appreciate it. try reinstalling again you should be able to find the enterprise manager probably you have downloaded the Express edition or you failed to set up the database engine and the client tools How the hell did you get the trial version to install Enterprise Manager Why is everything Microsoft so poorly developed ...Show All

• polymorphicx Scheduled job Step Output to Job History

  Hi I've been looking at kb 918760. In this, it says "You can also use the Include Step Output in the history option to redirect the logging information to a file or to the SQL Server Agent Job History." Now I'd really like to do this, but can't see this option anywhere nor can I find any reference to it in the help. Can anyone point me in the right direction Regards Guy Doh! Suspected it might be something like this ... Thank you This option is available when you use CmdExec Subsystem to execute your step, instead of SSIS Subsystem. From KB: About the exec subsystem command and output information By using the exec subsyst ...Show All

• Anmol Ranka ** critical issue with SSIS ** Please help!

  Hi all of you, This post is related with this one, previously opened: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=620243&SiteID=1 Moreover, this post is related too (IMHO) with http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=430406&SiteID=17 Following with my research I've seen that DTS.DLL is installed on: 1)My root c: 2)%systemroot%\system32 2)c:\archivos de programa\...\90\ 3)c:\archivos de programa\...\80\ It seems that BIDS is trying to call, at first, to this COM CCW component. So that, all has been deleted phsyically from my workstation and unregistered. Sql Server 2005 full installation again and... the problem lives yet.  I'm desperate     ...Show All

• Jack Spade Managing subscribers from remote machine?

  It looks like I can manage mostly everything within NS schema remotely, except subscribers and subscriptions. The SubscriberEnumeration class wants an NSInstance reference, which only works running on local SQL server. As it reads and writes directly to the registry. Is there something that I’m over looking to be able to enumerate the subscribers for an instance from a remote machine John I have looked through the enumeration class. It only works on the local SQL server; I cannot use the class on my client machine and manage the subscriptions remotely with it. I have although, found that for every Instance's database, there are stored procedures that i can call to get a list of subscribe ...Show All

• William Lowers Problem copy a table from SQLServer 2000 data base to SQLExpress database using SMO.

  I am trying to to copy a table from a SQLserver 2000 database to a new table in as SQLExpress database. The following is the code I used. Private Sub btnCopyTable_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCopyTable.Click Try mFromDatabase = New Database(mFromSrv, Me.cboSelectFromDatabase.Text) mToDatabase = New Database(mFromSrv, Me.cboSelectToDatabase.Text) 'mToDatabase.Create() Dim xfr As New Transfer xfr.CopyAllTables = False 'xfr.Options.WithDependencies = False 'xfr.Options.ContinueScriptingOnError = True xfr.DestinationDatabase = Me.cboSelectToDatabase.Text xfr.DestinationServer = mFromSrv.Name xfr.DestinationLoginSecure = True xfr.CopySchema = True xf ...Show All

• billg51 How to use a Table Variable

  Hi all, I have a table which holds a list of users names & the table assigned to each, e.g. - John Smith - Table1 - bob Jones - Table2 etc I have a store procedure which calls the information from the user's table based on the username. Something like this: Select * from @UserTable So if user is John Smith then @UserTable = Table1. Though the @ function does not work for referencing a table. Is there a workaround to this Rgds & thanks. A think that the only way is using an exec ou sp_executesql like this: Declare @command varchar(1000) Select @Command = 'Select * From ' + @UserTable Exec(@Command) or sp_executesql @Command Regards. How can I ta ...Show All