Search results for query: *

hi there we are looking to install SQL 2005 and 2008 side by side on a production server. I'm more than happy to do this on my own machine but wanted to ensure it is safe in a live environment. Any issues I need to look out for? Thanks Di

Hi all Im having a real strange problem i havent seen before. Ive got merge replication set up between two SQL 2005 machines. Ive just refreshed our UAT environment to match live, so restored the publisher and subscriber databases, configured replication and pushed out the snapshot. Ive done a...

Hi - thanks for the response. Yep, backups would be an easier method but there's an issue in that there are certain columns that will need to be scarmbled before its shipped over to dev (passwords, e-mail addresses, etc). I'm thinking the only way to get around that would be to DTS the data to a...

hi there i'm a dba and i am constantly being asked by the dev team for assistance with keeping their dev environments in sync with live in terms of data. Possibilities are DTS'ing data out on a nightly basis to their environments but that wouldn't work well for our replicated environments where...

Hi all I've been experiencing an interesting issue with a couple of of merge publications on our SQL servers. The error I am seeing is in the distribution agent history is: "The merge process could not perform retention-based meta data cleanup in database..." It happens regularly throughout...

Thanks for the responses guys. Here's what i have managed to come up with - hope it's useful to others out there. If anyone has any suggestions for improvements, let me know. <code> DECLARE @Count INT SET ROWCOUNT 5000 SELECT @Count=count(*) from Table1 SELECT @Count=@Count+count(*) from...

because i actually need to delete from several tables as part of a development release, and the tables are all involved in replication. I'm worried that replication will be adversley affected if all the deletes occurred at once and the distirbution agent tried to push out the info to the...

mm, actually what would be even nicer is if the script could loop until all records were deleted, in batches of 5000, with a minute delay between each delete. Can anyone help me with this?? thanks!

Hi all I need to delete records from a table in batches of 5000. The problem is that the id column for the table contains duplicates, so when i try this: delete table1 from (select top 5000 * from table1) as t1 where table1.testid = t1.testid it ends up deleting more than just 5000 rows. I...

Thanks for the quick response. SSIS is a good solution for this project as a whole, but what about the issue with them needing to keep track of the old data? When a customer does an update to a table it overwrites the data - but tehy need to do comparisons between the old values and the new...

Hi all I work as a production dba and our development team are trying to push a project which involves using triggers. The aim is to transfer information between to databases (on two differents servers) because currently users have to type in the same info into the two different systems. The...

Hi all I am using SQL 2000 (so this isnt the 2005 clean up bug). I have my backup job set to keep backups for 3 days, yet for some reason up to 5 are being kept on disk. Any ideas where to start looking? Thanks Div

Hi all I posted the following to the MSDN forum but didn't receive anything too useful back. Hoping to hear something back from you guys. Thanks Div > My team is responsible for designing the architecture of the web hosting > environment in my orgnaisation. We plan to implement an IIS web...

well, im using MDAC 2.8 on a win xp machine. Just gone into the About section in the ODBC Data Source Administrator and the version seems to be 3.525.1117.0 I've tried this on a windows 2003 server as well and had the same problem. Thx

I have made the default db for the user the test database in question. I can connect to query analyzer as that user and select/insert/update the tables within it. The user most def has rights to access the db... I thought there may be probs with my odbc drivers but the same thing happens on...

Thanks for replying. Unfortuantely that's not it. The login is definitely associated with the user. I created the db, created the login and gave it db data reader rights to the database. In that order. It's weird... Could there be something wrong with m ODBC drivers perhaps?

Hi all It's weird... ive created a test SQL 2000 database, defined a sql login with datareader rights to it, configured an odbc connection to point to it, selected SQL authentication and typed in my sql login - when it comes to the screen in the odbc configuration to select a database, i cannot...

hi All Thanks for the responses. This is for SQL 2000. Maybe i wasn't clear - i'm not trying to get the application working, it already works. The thing im trying to figure out is HOW it manages to work even though the sql user is not a member of sysadmin?? Because according to Books Online...

Hi there I'm doing some analysis on the database applications in my organisation before migrating the databases to a new server. One of these makes use of CDOSys objects for sending mail, instead of SQL Mail. There are a number of stored procedures within the database that call the sp_OACreate...

Hi there I'm doing some analysis on the database applications in my organisation before migrating the databases to a new server. One of these makes use of CDOSys objects for sending mail, instead of SQL Mail. There are a number of stored procedures within the database that call the sp_OACreate...