Search results for query: *

I realise that this will be a very subjective topic but I'm thinking of changing jobs and my potential new employers make extensive use of replication. Been working as a DBA for 5yrs and have never needed to use replication. Only read whats in BOL and MCP exam topics. Looking for a...

Hi all Quick background, clientsite was using SQL2000 and we had a DTS package which imported data from DB2/AS400 and then updated data in SQL2000. Something went haywire on server and can no longer access package. Clients solution is to upgrade to 2005 within 2 weeks. Clients didn't install...

Hi all Been awhile since I've been here. On one of our client sites we are DTSing data to and from JDE running on AS400. The package works fine when executed manually but every now and then the job fails. It seems as if the clients have messed up their sql server instances as the only way to...

Hi all I'm struggling with scheduling of destination sets. Our ISA Server was configured by an external company. They do the tricky stuff and we do the daily tasks. There is currently one Deny Destination set which is on all the time. I need to have the current set only avtive between 17:30...

Another thing to note is that you should run sp_change_users_login for the database like so: exec sp_change_users_login 'report' this will return a list of users in your database that don't matchup to a login on the new server. you might have to first create the missing login(s) on the...

Hi All THe server is running as DC(actually BDC) on W2K3 with SQL Server 2000. A domain user account was created to run the sql services but once the user and pwd have been entered and the service has been stopped, if you try and start the service we get an Access Is Denied error. Eventually...

Hi all The server is a BDC (as it was called in the good old days) running AD on w2k3.SQL Server 2000 is also running on this machine. A domain user account was created to run these SQL Server services. I add the accounts under services and grant log on as a service etc. I then stop the service...

well here is my 20c worth..... >>"but you never need to use a cursor in sql server". I have to disagree with your statement and agree with James and stravis. You can't generalise like that. If you never need to use cursors then why did Microsoft include it in SQL Server? Thats like...

Hi This link is more appropriate I think. http://support.microsoft.com/default.aspx?scid=kb;en-us;306212 John

Hi You can try using XACT_ABORT in your procedure an set its value to ON. SET XACT_ABORT ON ..... Have a look at the following article at Microsoft's support site. http://support.microsoft.com/default.aspx?scid=kb;en-us;329332 Hope this helps John

Hi Here is the link to the article: http://www.sql-server-performance.com/stored_procedures.asp John

Hi If you use the sp_ as a prefix for procedures and you execute the procedure in one of your user databases, SQL Server will first attempt to find the procedure in the master database and then the user database. THis would affect performance but you wouldn't even notice it. I don't remember...

Hi all I'm trying to determine what the pros and cons of having sql installed on the same machine as AD are. The server will actuall be the BDC(as it used to be called before AD came along),which will be the new dataserver of our company. Any assistance will be appreciated. Thanks John

Hi Try this: select id, name, seq from (your tablename) order by id, seq John

Hi You need to use the fully qualified name which consists of: DATABASE.OWNER.TABLE eg. select * from DB2.dbo.USER Since want a view you can right click on Views in DB1 in Enterprise Manager > New View and you can build your query there and save it as User. Alternatively you can use query...

Hi all I'm actually a DBA but our entire team is researching our problem. We use SQL 2000, ASP, W2K Server, IIS 5.0 and COM+. We have an issue with our application where the objects are being "stolen" between sessions/processes. Eg. In one session your logon info is domain\john and...

Hi all I'm actually a DBA but our entire team is researching our problem. We use SQL 2000, ASP, W2K Server, IIS 5.0 and COM+. We have an issue with our application where the objects are being "stolen" between sessions/processes. Eg. In one session your logon info is domain\john and...

Hi I'm guessing that you are running SQL 2000 and that your database uses the FULL recovery model and that you don't backup your database frequently? By default the FULL recovery model is used in SQL 2k unless SIMPLE or BULK-LOGGED are specified. Using FULL is the best as it writes every...

Hi You can DECRYPT stored procedures. Create the following procedure and then execute it by passing in the ENCRYPTED procedure's name. create PROCEDURE sp_decrypt_sp (@objectName varchar(50)) AS DECLARE @OrigSpText1 nvarchar(4000), @OrigSpText2 nvarchar(4000) , @OrigSpText3...

Hi all Would have use the keyword search but it is still down. Is there away to generate a txt file from within a stored procedure without using xp_cmdshell? Currently we use xp_cmdshell dtsrun, this is being called within about 20 procedures. We are executing it manually on an adhoc basis...