Viewing 15 posts - 511 through 525 (of 525 total)
You can have the AccDB pick up and send the table to the end-user with the docmd.sendobject command as an excel spreadsheet. You can even fire the access using the...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 29, 2004 at 9:35 am
Microsoft Knowledge Base Article - 319951
HOW TO: Transfer Data to Excel by Using SQL Server Data Transformation Services
http://support.microsoft.com/default.aspx?scid=kb;en-us;319951&Product=sql2k
From the article:
If you select the drop and re-create the destination...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 29, 2004 at 8:38 am
Couldn't see the screenshot......
A couple of questions....
Are you trying to back up all the databases under 1 plan?
If so, are all databases in "Trunc. Log On Chkpt." mode?
Are you attempting...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 28, 2004 at 1:38 pm
No. Just go multi-user.
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 28, 2004 at 10:51 am
Check your timeouts.
Also how are you connecting to the server? Named pipes? Try changing to/adding TCP/IP. Are you connecting using the IP address or a DNS name? Check your DNS...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 28, 2004 at 10:15 am
Do you have a spare/different SQL server? Try restoring the DB on that server. See if it looks okay. Then detach the database on server B and reattach on Server...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 28, 2004 at 9:14 am
Check KB articles:
http://support.microsoft.com/default.aspx?scid=kb;en-us;308886&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;811205&Product=sql2k
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 28, 2004 at 8:04 am
Missed something small but important, the database name.
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Also, don't forget to separate the commands with a "GO" if you are trying...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 28, 2004 at 7:54 am
Thanks for the update.
I'm not using the e-mail code yet. I'm trying to build up a stats database that get DB sizes, disk size, last backup (log and transaction), recovery...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 23, 2004 at 10:36 am
I agree it is a great script.
I did minor mods to to handle checking remote servers. Also, if you fire it from the...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 22, 2004 at 3:34 pm
Sorry - my bad. I only had ASCII 0-127 hanging on my wall. I just printed the 128-255 now. The best place I...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 22, 2004 at 1:46 pm
The double pipe "||" is a concantenation character in Oracle (and some other DB systems). It is probably being recognized as a special character and translates out as ASCII Char...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 22, 2004 at 12:31 pm
I'm working on a procedure that collects all this data into one location so I have to use your select statements.
Just wanted to mention that I've come up with a...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 21, 2004 at 3:35 pm
Knowledge Base article 128809
http://support.microsoft.com/default.aspx?scid=kb;en-us;128809&Product=acc97
This is because of index(es), or lack of, on the SQL table. If you can't alter the SQL database to put an index on the...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 21, 2004 at 1:55 pm
ALTER DATABASE Northwind
SET SINGLE_USER
WITH ROLLBACK AFTER 30 SECONDS
Did they change this in SQL2K from SQL7? I ran it against my SQL7 server and got the following message.
Server: Msg 156, Level...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
August 29, 2003 at 7:04 am
Viewing 15 posts - 511 through 525 (of 525 total)