What Topics are you labeling "advanced"? What areas of SQL Server are you interested in learning more about? SSIS, Replication, performance tuning, ...

Give us some areas that interest you...

Molly,

For your NULL issue, look up the ISNULL Function in SQL Server Books On Line (BOL). It will allow you to change the value in the given column from...

From a SQL Server 2000 patch perspective, I would recommend you document the current version of each database server.

The current SQL Server 2000 patch is 2000 SP4+916287/914384/898709/915065/915340 (version: 8.00.2187)

A cumulative...

Molly,

The best way to learn is "under fire"! 😎

Can you drop/recreate the view? If so then ...

1) Post create table statement of the base table in question.

2) Post the Create...

Molly,

Have you considered creating a View with the modified column structure, or a series of calculated columns off of the original "free form" Column?

If so, you could create your view,...

A bit of a warning.

The DB2 Driver in the Feature pack will only work with

SQL Server 2005 Developer Edition

OR

SQL Server 2005 Enterprise Edition.

If using SQL Server 2005 Standard Edition....

Jeff451,

A few things come to mind that you can try.

1) Is your machine patched to the same SQL Server version of the Database server?

(Open SSMS on the workstation Help...

WinRAR is a compression tool similar to Zip/Winzip. My guess is that someone on the server is using WinRAR to compress files. Search the machine for *.RAR (WinRAR...

John,

I have a conceptual idea of what you want to do. You will have the least amount of headache by working as much as possible within SQL Server, in...

Additionally I would recommend disabling the user for a period of time, say a month, before deleting. Giving you time to object change ownership to the proper account.

In a...

figaro,

This should get you started ...

-- SQL Server 2000

-- Column Comments pulled from SQL Server Books OnLine

-- (BOL) topic: sys.logins(Transact-SQL)

-- Selected columns from master.dbo.syslogins Table.

select

createdate -- Date the...

I believe you are looking for "cross-tab" functionality in Crystal. I am using Crystal Reports Developer, Full version 11.0.0.1282 (I need to update to 11.5). The help file...

Phil,

Here are my notes on dealing with (detecting and correcting) Orphaned Users. Everything should work with SQL Server 2000 and SQL Server 2005.

--

Source: http://support.microsoft.com/kb/274188/

PRB: "Troubleshooting Orphaned Users" Topic in...

tvu4251,

I had a similar situation with a Server Admin at a previous company. He was nice and friendly in meetings, in front of others, etc. When I would...

Ravi,

Thanks a lot for taking the time to put this together (and thanks to whoever else it took to get the technical parts working).

That was a nice little "coffee break"...