I did some more digging after I posted this and came across the COLLATE keyword. At first I thought this was only used to set columns and the database to a certain collation at creation of the...

Currently our database is set to case-insensitive so when I search for the word "Math" I can get "MATH" or "Math" and even "math". Now I would like to run a script that searches for any word that is...

Hi dickersonka,
Thanks for the info. If you don't mind me asking, how many connections does your VMs get on average and how big are your databases? I'd like to know, because our connections will...

Has anyone moved their SQL Server's into a virtual environment using VMware? If so, what has your experience been like?

thanks,
GM

You really didn't need to create a new thread since this still relates to your previous one.

Looking at the error message about NOLOCK, I came across this article from Microsoft http://support.microsoft.com/kb/815008. But, this is for SQL Server 2000, which you said you are using 2005....

Sounds more like you need to update the existing records that have a group id of 7 and change those to 12, but if you need both groups to be related to the same products as ID 7, then an insert...

I remember with SQL Server 2005 Express, Microsoft had a separate install package that did not include the Full-Text support. You may want to check for a SQL Server 2008 package that includes...

Personally, I would refrain from using any data transformations in this manner. Changing the data being inserted by the user does comply with the check constraint, but it alters what the user is...

Ramy's and MSI's solutions work perfect if you have to use the LIKE clause, but DATETIME data types need to be handled differently. I would recommend not using the LIKE clause and going with the SQL...

I haven't ever looked at creating constraints yet, most of my time has been looking at maintenance plans. So this is still new to me, but all of the examples I have seen are a static pattern. None...

If your table has multiple records per employee as in

EmployeeID, EmployeeName
------------------------------------
12345, John Smith
12346, Jane Doe
12345, John Smith
12347, Bob Smith

You...

Take a look at the PIVOT command in Books Online.

Most likely you will not be able to do this using a simple insert or update sql statement, so you will need to create a stored procedure to handle this task. I'm not exactly sure what functions exist...

If you have any basic questions, most of them can be answered by reading SQL Server's Books Online at http://msdn.microsoft.com/en-us/library/ms130214.aspx. This is a must have for anyone working...

Using the like constrait with '%00' would work for this sample, but would still require the human eye to make the associations with each possible duplicate. I'm not exactly sure what the solution...

In both SQL 2000 and 2005 you can run this query using the information_schema.columns

SELECT
data_type,
column_name
FROM information_schema.columns
WHERE table_name = 'table'

This...

This is just a suggestion, but you might want to normalize that table into two separate tables: TicketMaster and TicketMessages.

TicketMaster
id (int)
inserted (smalldatetime)
lastUpdated...

It is rare that you would want to give someone complete access to all the objects pertaining to a schema. An example would be the HumanResources schema which has sensitive material that not all...

I'm not sure if this will help your case but from what you are asking it sounds like you want to group records based on an attribute and determine the maximum value of each attribute.

If you have...

But 2005 allows you to grant users the right to run SQL statements to individual schemas. I do understand that schemas are collections of database objects, but it seems SQL 2005 is mixing the...

In this example I'm using the AdventureWorks database in MS SQL Server 2005

I was wondering what other people thought about Schemas vs. Roles when it comes to security access. If you have an...

Just to add on what version I'm running is that it is SQL 2000.

I emailed the list server for our vendor and I was informed that the table I'm working with used to not start at 1 for every individual's sequence number. So they updated it a while back. I was using...

Thanks mellamokb for the reply and the code. I ran what you created and there is only one error that shows up. It doesn't like the t1.ID_NUM on the where statement t2.ID_NUM = t1.ID_NUM. It tells me...

Hey everyone,

This problem I've been working with has got me stumped. Let me show you the table layout first.

ID_NUM int,
SEQ_NUM int,
ATTRIBUTE_CODE char(2),
ATTRIBUTE_DEF char(50),...

Has anyone attempted virtualizing Microsoft SQL Server 2000/2005 using VMWare or MS Virtual Server? I've heard from others in the field that they wouldn't virtualize a database server relating to...

What version is your SQL Server: 2000 or 2005? Also what edition is your SQL Server: express, evaluation, developer, workgroup, standard, or enterprise?

are you using the command line tool OSQL?

I would check your collation schema for that database. For those who don't know what I'm talking about. A collation defines how SQL will handle unicode characters. Most likely you have your collation...

Well it really doesn't matter if the two databases are on different servers. All that you need to know is that you must have access to both servers. Then use DTS to copy the table object over.
...

I am assuming that both databases are on the same SQL Server instance. If you want to transfer a table between databases, try using DTS if you are on SQL 2000. There should be a method for...

For starters, I did notice that your right hand column is spelt different. Should it be op.OpportunityID?
Your Code
WHERE OpportunityID = op.OpportunituID
Possible Correction
WHERE OpportunityID...

As a long term fix, I would suggest altering the data table to include a code or date field to go by in the future. That's if you have authorization to alter the data table.

It really depends on what version of SQL Server you are using. SQL 2000 requires that you have Outlook installed on the server that is hosting SQL. On the other hand, SQL 2005 is using SMTP instead...

Since there is an OLE DB for Directory Services, can you do more than view AD objects? ADSI is an OLE DB provider and it can, so can you manipulate AD using SQL queries once you establish a linked...

On another forum they showed me that this was supposed to be better than what I was coding.

SELECT *
FROM tableA a
WHERE NOT EXISTS
(
SELECT *
FROM tableB b
WHERE a.id_num = b.id_num
...

I did find this to work, but would like to know if there is a better way.

SELECT tableA.* FROM tableA LEFT JOIN tableB
ON tableA.id = tableB.id
WHERE tableB.id IS NULL

The ON clause will only look for ID numbers that are equal to each other.

ON a.id_num = b.id_num

how can I join the two tables to show only the distinct records in table [a].

I found the EXCEPT operator for SQL 2005, but I don't think it's available in SQL 2000. What alternative can you use?