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 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...

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...

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...

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 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...

Hi there...i don't know if this is more an IIS thing or a .net thing, but i'm trying to figure out why it is sometimes required for the IISAdmin service to be restarted in order for changes to the web.config file to be picked up? For example, changes to database connection strings...At first i...

Hi all, Is there some sort of sproc or query that i can run to identify all the computed columns within tables, within a particular db? Thx! Div

Hi all, I manage a couple of Biztalk servers in my organisation - Biztalk has a number of databases associated with it and when you install it, it automatically creates a Biztalk db backup job which you are supposed to use (and not modify) for all Biztalk backups. Unfortunately this job does...

hi all, i need to restore a copy of a live database to a dev machine to use for testing. The live database is being replicated to another server & so contains some metadata to do with replication - but i dont really want the test database to contain any of this metadata. Does anyone know...

Hi all, I recently started getting alerts from one of our sql servers where replication is set up - this is due to a publication that is listed in the replication monitor view in ent mgr, which when you right-click it to view its properties you get an error that it does not exist. I don't know...

Hi all...i'll be migrating some databases to a new server and am looking at all the dependencies and extra stuff that needs to be moved along with the DBs - such as full-txt catalogs. I've run a few stored procedures to identify which databases have full-txt catalogs - but even though they exist...

...do they still have database access? i.e. in the properties of the login, on the User Mapping tab there are no ticked DBs..does that mean that login doesn’t actually have any access to any db, even though it is sysadmin? I mean from an application perspective... I know that the sa password...

Hi all I'm doing a review of all the DTS packages we have running on a particular server. I need to find out the last run time on a couple of these - i assume i can find this out by looking in the DTS package logs, but what's weird is that when i in the package log screen, where you get a list...

Hi all I'm responsible for moving a number of databases from our old SQL cluster to our new one. A lot of these are pretty old and trying to get more information about them is proving to be quite difficult. There are a couple of linked servers which are using the MSIDXS provider - that is...