Viewing 15 topics - 271,501 through 271,515 (of 283,885 total)
Topics
Started by
Posts
Last post
Hi All, In the database I have two a user called alec, who owns few tables and procedures. When I t…
3 replies
Prior to the net admins installing the patch to 'sure' up the loop hole for the virus, I was able t…
8 replies
In Oracle, I can use RowNum like this SQL> select rownum, product_id from products; ROWNUM PROD…
5 replies
Hi there. I did an install of MSDE on my server and for the life of me, cant remember the SA passwo…
4 replies
Hi All, is there any way I can change the owner of all the objects in my database in one go. the…
8 replies
Been doing backups across network using UNC and am suddenly getting "Operating system error 64(The …
6 replies
Does anybody know how to get the Server name(Windows 2000) from a SQL2k active/active cluster envir…
8 replies
Hi I want to convert data from 26/08/2003 once into 08/26/03 and once into 26/08/03 10:00 This is …
3 replies
Do we need to delete old job history from system tables in MSDB? I have not deleted this for a whil…
4 replies
In SQL client MS has not built in support for un-named parameters. Named parameters is default and …
6 replies
Does anyone have any experience with the undocumented extended stored Procedure xp_execresultset? I…
1 replies
Does t-sql have any support for mathematical sets. I'd like to treat a row as a set and perform dif…
2 replies
To access 16 Gb of memory you don't need 64-bit version of SQL 2000: http://www.microsoft.com/sql/e…
3 replies
Hi All, I tried running two queries , The First one does an insert into a permanent table using som…
3 replies
Hi there, any ideas, tips, tricks on this are highly appreciated! Cheers, Frank -- Frank Kalis Micr…
8 replies
Viewing 15 topics - 271,501 through 271,515 (of 283,885 total)