Viewing 13 posts - 1 through 13 (of 13 total)
Michael Hotek has a series of tutorials that can be downloaded from here: http://www.mssqlserver.com/tsql/
Best regards,
Andrew
April 11, 2005 at 4:46 am
Hello,
I had this problem once and a way round it was script the database making sure to check the only...
March 8, 2005 at 2:23 am
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
December 23, 2004 at 3:16 am
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,...
November 17, 2004 at 4:13 am
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...
November 17, 2004 at 2:23 am
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...
October 21, 2004 at 7:58 am
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), newid()),'-','_')
--would...
May 12, 2004 at 3:00 am
Hi,
There are quite a few known problems upgrading directly from 6.5 to 2000. Without...
April 16, 2004 at 2:34 am
Hi,
I have had to do something similar and the way I managed it was...
April 13, 2004 at 2:53 am
Hi,
Have you considered using a look-up calendar table that could store all non working...
April 8, 2004 at 3:09 am
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...
February 27, 2004 at 8:20 am
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
February 27, 2004 at 3:13 am
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...
February 10, 2004 at 5:56 am
Viewing 13 posts - 1 through 13 (of 13 total)