Yes. But if I would like to have number of transactions in any day, how do we do that. I am trying to setup a table to show how many...

I thought we cannot see when a table was last updated. We surely can check when a table was created though in sysobjects in all the user database.

lowell,

Very much reasonable and appreciate your suggestion.

Excellent Suggestion. I down the line, this will be usedful to most of the members (if it becomes available).

You might want to look check the Properties of the SQL Server in EM. You might find some info in the Processor page. In Parallelism section of the page, I...

I am also getting the same error on the SQL 7.00.996 Production Server which I don't have Administrative access to (since its another dept server). I have only SELECT accesss...

Excellent. Thank You neiljacobson.

I did try this (select @@servername) and this miraculous name did apprear there. I am going to drop and add the server again. Actually this server...

Thanks to All. my problem solved.

Also related to this, How do we see system stored procedures and system tables in SQL Sever 6.5 EM? I can grant access using DBArtisan for them. But I don't...

You could certainly find that from Installation CD. You can run SETUP.EXE again and select add/remove.

vikramnat,

Here is the link for SQL 7.0 updated books online:

http://download.microsoft.com/download/SQL70/File/2/Win98/En-US/SQLBOL.exe

For all SQL Server Service Packs & Books Online Updates, you can check in the following page:

http://support.microsoft.com/default.aspx?PR=sql#faq276

Regards,

Murali Damera.

Any Thought?!?!?

This is how we have the script (as FTPSEND.TXT for one of our jobs:

quote:

---

open MF01

userid

password

delete 'mainframe.data.set'

quote SITE LRECL=90 BLKSIZE=0 RECFM=FB TRACKS PRI=200...

is your userid and the id mentioned in the inFTP.txt the same?!

You can try this:

1. goto command prompt.

2. manually type ftp 209.63.127.202

3. give userid

4. give password

type the following one after...

After checking the access rights for userid mentioned in the ftp script(c:\ftpSend.txt), try running this manually thru Query Analyser.