Michael Hotek has a series of tutorials that can be downloaded from here: http://www.mssqlserver.com/tsql/ 

Best regards,

Andrew

Hello,

I had this problem once and a way round it was script the database making sure to check the only...

If you want a specific format you could alway use something like

SELECT LEFT(CONVERT(varchar, GETDATE(), 113),17)

23 Dec 2004 10:04

Best regards,

Andrew

If you want to assign the owner to, say, sa then run

EXEC sp_changedbowner 'sa'

You will find that dbo appears as a user and is identfied as 'sa'

Hope this helps,...

I had a similar problem - seems to be a memory leak type issue (could find no useful information) in the end it required a reboot when eventually we could...

I have found that the easiest way to get the a SQL Server query to work correctly when querying a remote Oracle database is to connect to it using sqlplus...

Going back to the temporary global table idea would it not be possible to do something like:

declare @temp varchar(36)

declare @sql nvarchar(1000)

set @temp='##'+replace(convert(varchar(36),...

Hi,

There are quite a few known problems upgrading directly from 6.5 to 2000.  Without...

Hi,

I have had to do something similar and the way I managed it was...

Hi,

Have you considered using a look-up calendar table that could store all non working...

I’ve used Oracle since 7.3 and although it has got more ANSI compliant with 9i I have generally found it best to use the Oracle’s...

Hi,

Oracle uses functions to convert data types rather than cast/convert.  If I recall correctly you use

to_date('string', 'format')

have a look at http://www-db.stanford.edu/~ullman/fcdb/oracle/or-time.html

hope this helps

Something similar happened to me a while ago but with databases rather than servers.  In that case I was using SQL 2000 EM to take...