I have a table with 3 columns ( customer#, line_number, description) what I like to do is to merge all the text for each customer into a new table with two columns (customer#, text …

Hi, I have been trying to configure DB Mirriring using the below T-SQL NOTE: I DO NOT have a witness I am trying to configure Mirroring on a single server with two SQL instances. …

Hello, I need to migrate a large Access Module, to perform it's evaluation onto a SQL Server. Background: I have developed two Access modules (VBA) for a customer. Each day, data …

Can you run Sql Server 2000 & SQL 2005 Express simultaneously on the same server without any issues?

I need help in writing a query.I have 4 tables which are related: Works WorkTypeProperties WorkTypes WorkProperties Now if i join all these tables i get the result using this q …

I need to output the results of a query to a CSV file then send to somebody on email. I would like to schedule this automatically on a SQL Server so is it possible to create tha CS …

Hi Guys and Girls! I am setting up a replication solution for a customer, replicating 7 tables, but not all columns in the tables. Publisher and distributor are on SQL 2005 Std, s …

how to figure out the sql server instance name, with given box name and the port number. Another question, i have is .. how to know what ports are enabled for the particular sql se …

Hi, I thought I posted this question last week but cannot find trace so apologies if I duplicate it: I have a requirement to total across a row but only columns in a user specifie …

Hi all My ServerParametersInstance table in the ReportServer db is growing at an alarming rate (200 rows per min during the working day). I have google'd this and some suggestions …

Hi All, I have these job running early morning everyday and at least once a week the job fails with the following error message: Executed as user: xxx\Administrator. Transa …

Noticing several hundred random failed login attempts on my MSSQL Server Instance. These are fairly obvious to me as attacks as I know the IP ranges of users that are allowed acces …

I am trying to write some code that I hope will run on SQL Server 2000, 2005, 2008 and beyond. I currently have 2008 R2 on my machine but I would also like to test it will work on …

I have the following code querying Users and Roles in a database and I would like to pivot it by user and have Roles across the top with an 'X' showing which roles the users have s …

How are different types of multimedia data modelled, accessed and manipulated by SQL Server 2005???