Showing posts with label program. Show all posts
Showing posts with label program. Show all posts

Thursday, March 29, 2012

Duplicate table

Hi,
In my program i need to duplicate a table in a current data base.
I'm thinkin' of reading the data base columns and then rows and so i
create another table
Is there any other easy and fast method with SQL Server 2005, because
my idea is so slow
I'm using VB 2005 Express with SQL Server 2005 Express
Thanks
To duplicate the table columns and data, just:
SELECT * INTO Newtable FROM Oldtable
However this will not copy indexes, access privileges, etc.
To get everything you must script the table to create it, and then add the
data, perhaps with
INSERT INTO NewTable SELECT * FROM Oldtable
Of course, using column names instead of * would be a better practice.
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Omar Abid" <omar.abid2006@.gmail.com> wrote in message
news:1181578789.815330.212000@.q69g2000hsb.googlegr oups.com...
> Hi,
> In my program i need to duplicate a table in a current data base.
> I'm thinkin' of reading the data base columns and then rows and so i
> create another table
> Is there any other easy and fast method with SQL Server 2005, because
> my idea is so slow
> I'm using VB 2005 Express with SQL Server 2005 Express
> Thanks
>
|||> INSERT INTO NewTable SELECT * FROM Oldtable
> Of course, using column names instead of * would be a better practice.
And might be necessary, e.g. for IDENTITY/ROWVERSION...
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006

Duplicate table

Hi,
In my program i need to duplicate a table in a current data base.
I'm thinkin' of reading the data base columns and then rows and so i
create another table
Is there any other easy and fast method with SQL Server 2005, because
my idea is so slow
I'm using VB 2005 Express with SQL Server 2005 Express
ThanksHi
On Jun 11, 5:19 pm, Omar Abid <omar.abid2...@.gmail.com> wrote:
> Hi,
> In my program i need to duplicate a table in a current data base.
> I'm thinkin' of reading the data base columns and then rows and so i
> create another table
> Is there any other easy and fast method with SQL Server 2005, because
> my idea is so slow
> I'm using VB 2005 Express with SQL Server 2005 Express
> Thanks
If you just want to create copy the data then you could use
SELECT *
INTO #temptable
FROM Mytable
Which will create a new table with the contents of the old table, but
the new table will not have the constraints such as primary or foreign
keys and indexes that the original table had. If you dont want the
table but just the columns use a where clause that will never be
satisfied such as
WHERE 1 = 0
Alternatively you can use SMO see Allen Whites posts in the thread
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=876099&SiteID=1
John

Duplicate table

Hi,
In my program i need to duplicate a table in a current data base.
I'm thinkin' of reading the data base columns and then rows and so i
create another table
Is there any other easy and fast method with SQL Server 2005, because
my idea is so slow
I'm using VB 2005 Express with SQL Server 2005 Express
Thanks
SELECT * INTO NewTable FROM OldTable
Andrew J. Kelly SQL MVP
"Omar Abid" <omar.abid2006@.gmail.com> wrote in message
news:1181578846.356369.101240@.n4g2000hsb.googlegro ups.com...
> Hi,
> In my program i need to duplicate a table in a current data base.
> I'm thinkin' of reading the data base columns and then rows and so i
> create another table
> Is there any other easy and fast method with SQL Server 2005, because
> my idea is so slow
> I'm using VB 2005 Express with SQL Server 2005 Express
> Thanks
>

Duplicate table

Hi,
In my program i need to duplicate a table in a current data base.
I'm thinkin' of reading the data base columns and then rows and so i
create another table
Is there any other easy and fast method with SQL Server 2005, because
my idea is so slow
I'm using VB 2005 Express with SQL Server 2005 Express
Thanks
Hi
On Jun 11, 5:19 pm, Omar Abid <omar.abid2...@.gmail.com> wrote:
> Hi,
> In my program i need to duplicate a table in a current data base.
> I'm thinkin' of reading the data base columns and then rows and so i
> create another table
> Is there any other easy and fast method with SQL Server 2005, because
> my idea is so slow
> I'm using VB 2005 Express with SQL Server 2005 Express
> Thanks
If you just want to create copy the data then you could use
SELECT *
INTO #temptable
FROM Mytable
Which will create a new table with the contents of the old table, but
the new table will not have the constraints such as primary or foreign
keys and indexes that the original table had. If you dont want the
table but just the columns use a where clause that will never be
satisfied such as
WHERE 1 = 0
Alternatively you can use SMO see Allen Whites posts in the thread
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=876099&SiteID=1
John
sql

Duplicate table

Hi,
In my program i need to duplicate a table in a current data base.
I'm thinkin' of reading the data base columns and then rows and so i
create another table
Is there any other easy and fast method with SQL Server 2005, because
my idea is so slow
I'm using VB 2005 Express with SQL Server 2005 Express
ThanksOmar Abid <omar.abid2006@.gmail.comwrote in news:1181578579.728121.204320
@.g4g2000hsf.googlegroups.com:

Quote:

Originally Posted by

Hi,
In my program i need to duplicate a table in a current data base.
I'm thinkin' of reading the data base columns and then rows and so i
create another table
Is there any other easy and fast method with SQL Server 2005, because
my idea is so slow
I'm using VB 2005 Express with SQL Server 2005 Express
Thanks
>
>


SELECT * INTO NewTable FROM OldTable|||On 11 juin, 18:54, "Chris.Cheney" <Chris.CheneyXXNOSPA...@.tesco.net>
wrote:

Quote:

Originally Posted by

Omar Abid <omar.abid2...@.gmail.comwrote in news:1181578579.728121.204320
@.g4g2000hsf.googlegroups.com:
>

Quote:

Originally Posted by

Hi,
In my program i need to duplicate a table in a current data base.
I'm thinkin' of reading the data base columns and then rows and so i
create another table
Is there any other easy and fast method with SQL Server 2005, because
my idea is so slow
I'm using VB 2005 Express with SQL Server 2005 Express
Thanks


>
SELECT * INTO NewTable FROM OldTable


Hi
Thx for your reply I'll try your code and submit the result to you
Omar Abid

Duplicate table

Hi,
In my program i need to duplicate a table in a current data base.
I'm thinkin' of reading the data base columns and then rows and so i
create another table
Is there any other easy and fast method with SQL Server 2005, because
my idea is so slow
I'm using VB 2005 Express with SQL Server 2005 Express
ThanksHi
On Jun 11, 5:19 pm, Omar Abid <omar.abid2...@.gmail.com> wrote:
> Hi,
> In my program i need to duplicate a table in a current data base.
> I'm thinkin' of reading the data base columns and then rows and so i
> create another table
> Is there any other easy and fast method with SQL Server 2005, because
> my idea is so slow
> I'm using VB 2005 Express with SQL Server 2005 Express
> Thanks
If you just want to create copy the data then you could use
SELECT *
INTO #temptable
FROM Mytable
Which will create a new table with the contents of the old table, but
the new table will not have the constraints such as primary or foreign
keys and indexes that the original table had. If you dont want the
table but just the columns use a where clause that will never be
satisfied such as
WHERE 1 = 0
Alternatively you can use SMO see Allen Whites posts in the thread
http://forums.microsoft.com/MSDN/Sh...876099&SiteID=1
John

Wednesday, March 21, 2012

Dump SQLExpress Data

Does SQL Server have a command line program that can dump a whole database
into sql insert statements. I would like to reload the whole database on
another computer.
Arne Garvander
(I program VB.Net for fun and C# to get paid.)
Hi Arne
"Arne Garvander" wrote:

> Does SQL Server have a command line program that can dump a whole database
> into sql insert statements. I would like to reload the whole database on
> another computer.
> --
> Arne Garvander
You may want to check out the suggestions on
http://www.karaszi.com/SQLServer/info_generate_script.asp
John
|||So you are suggesting third party tools.
Thanks.
Arne Garvander
(I program VB.Net for fun and C# to get paid.)
"John Bell" wrote:

> Hi Arne
> "Arne Garvander" wrote:
>
> You may want to check out the suggestions on
> http://www.karaszi.com/SQLServer/info_generate_script.asp
> John
|||Arne Garvander wrote:
> Does SQL Server have a command line program that can dump a whole database
> into sql insert statements. I would like to reload the whole database on
> another computer.
>
Why not just use the BACKUP and RESTORE commands? Backup the database
on one machine, then restore it on the other. No need for insert
statements.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Hi Arne
"Arne Garvander" wrote:

> So you are suggesting third party tools.
> Thanks.
> --
> Arne Garvander
Some are tools, some are scripts to generate the INSERT statements. I would
go with BACKUP and RESTORE as suggested by Tracy or even BCP which are far
better ways to load significant amounts of data than loads of INSERT
statements.
John

Dump SQLExpress Data

Does SQL Server have a command line program that can dump a whole database
into sql insert statements. I would like to reload the whole database on
another computer.
--
Arne Garvander
(I program VB.Net for fun and C# to get paid.)Arne Garvander wrote:
> Does SQL Server have a command line program that can dump a whole database
> into sql insert statements. I would like to reload the whole database on
> another computer.
>
Why not just use the BACKUP and RESTORE commands? Backup the database
on one machine, then restore it on the other. No need for insert
statements.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Try http://www.sqlscripter.com to generate data scripts.
"Arne Garvander" wrote:
> Does SQL Server have a command line program that can dump a whole database
> into sql insert statements. I would like to reload the whole database on
> another computer.
> --
> Arne Garvander
> (I program VB.Net for fun and C# to get paid.)

Monday, March 19, 2012

Dump SQLExpress Data

Does SQL Server have a command line program that can dump a whole database
into sql insert statements. I would like to reload the whole database on
another computer.
Arne Garvander
(I program VB.Net for fun and C# to get paid.)Hi Arne
"Arne Garvander" wrote:

> Does SQL Server have a command line program that can dump a whole database
> into sql insert statements. I would like to reload the whole database on
> another computer.
> --
> Arne Garvander
You may want to check out the suggestions on
http://www.karaszi.com/SQLServer/in...rate_script.asp
John|||So you are suggesting third party tools.
Thanks.
--
Arne Garvander
(I program VB.Net for fun and C# to get paid.)
"John Bell" wrote:

> Hi Arne
> "Arne Garvander" wrote:
>
> You may want to check out the suggestions on
> http://www.karaszi.com/SQLServer/in...rate_script.asp
> John|||Arne Garvander wrote:
> Does SQL Server have a command line program that can dump a whole database
> into sql insert statements. I would like to reload the whole database on
> another computer.
>
Why not just use the BACKUP and RESTORE commands? Backup the database
on one machine, then restore it on the other. No need for insert
statements.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi Arne
"Arne Garvander" wrote:

> So you are suggesting third party tools.
> Thanks.
> --
> Arne Garvander
Some are tools, some are scripts to generate the INSERT statements. I would
go with BACKUP and RESTORE as suggested by Tracy or even BCP which are far
better ways to load significant amounts of data than loads of INSERT
statements.
John

Sunday, March 11, 2012

Dual-boot with SQL 2000

A client has a program that uses a SQL database. They already have a Windows
2003 + SQL 2000 SP3a server they had planned to use with this app, then
discovered the vendor only will not support Windows 2003 + SQL 2000 SP3a
until the end of the year.
Our thought is to install Windows 2000 + SQL 2000 as a dual-boot with the
existing Windows 2003 + SQL 2000 installation. Set the SQL database and log
folders to the same folders in both installations, and when the vendor
certifies Windows 2003, boot into 2003 and immediately resume operations
with minimal downtime.
Is this workable? Or do we need to keep the two SQL installations completely
separate and do a backup from Win2000/SQL2000 and then restore to
Win2003/SQL2000?
--
Jeff Vandervoort
JRVsystems
http://jrvsystems.comAssuming that the folder for all database files are the same and the machine name is the same, yes
it should work. Not supported, though.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jeff Vandervoort" <jeffv @. jrvsystems dot com> wrote in message
news:%2390OgxPnDHA.3612@.TK2MSFTNGP11.phx.gbl...
> A client has a program that uses a SQL database. They already have a Windows
> 2003 + SQL 2000 SP3a server they had planned to use with this app, then
> discovered the vendor only will not support Windows 2003 + SQL 2000 SP3a
> until the end of the year.
> Our thought is to install Windows 2000 + SQL 2000 as a dual-boot with the
> existing Windows 2003 + SQL 2000 installation. Set the SQL database and log
> folders to the same folders in both installations, and when the vendor
> certifies Windows 2003, boot into 2003 and immediately resume operations
> with minimal downtime.
> Is this workable? Or do we need to keep the two SQL installations completely
> separate and do a backup from Win2000/SQL2000 and then restore to
> Win2003/SQL2000?
> --
> Jeff Vandervoort
> JRVsystems
> http://jrvsystems.com
>|||Thanks for your reply, Tibor.
--
Jeff Vandervoort
JRVsystems
http://jrvsystems.com
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:%235lyAISnDHA.2312@.TK2MSFTNGP12.phx.gbl...
> Assuming that the folder for all database files are the same and the
machine name is the same, yes
> it should work. Not supported, though.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Jeff Vandervoort" <jeffv @. jrvsystems dot com> wrote in message
> news:%2390OgxPnDHA.3612@.TK2MSFTNGP11.phx.gbl...
> > A client has a program that uses a SQL database. They already have a
Windows
> > 2003 + SQL 2000 SP3a server they had planned to use with this app, then
> > discovered the vendor only will not support Windows 2003 + SQL 2000 SP3a
> > until the end of the year.
> >
> > Our thought is to install Windows 2000 + SQL 2000 as a dual-boot with
the
> > existing Windows 2003 + SQL 2000 installation. Set the SQL database and
log
> > folders to the same folders in both installations, and when the vendor
> > certifies Windows 2003, boot into 2003 and immediately resume operations
> > with minimal downtime.
> >
> > Is this workable? Or do we need to keep the two SQL installations
completely
> > separate and do a backup from Win2000/SQL2000 and then restore to
> > Win2003/SQL2000?
> >
> > --
> >
> > Jeff Vandervoort
> > JRVsystems
> > http://jrvsystems.com
> >
> >
>

Wednesday, March 7, 2012

dtswizard login problem?

Hey, i'm trying to use the dtswizard.exe program in MS SQL Server Express 2005 to move a database from one computer on my home network to another.

- Both SQL servers are using Windows Authentication.

-I've turned off all firewalls

-I've done all the Surface Area Config stuff and enabled both types of remote connections

But i'm still getting a "Login Failed for user 'BASEMENT/Guest'. (Microsoft SQL Native Client)" error.

Any ideas?

Thanks!

There is no DTS in Express and why are you using the guest account SQL Server's guest account is off limits to human users because SQL Sever services use it. Problems with the guest account can make your SQL Server shut down. And in one network the normal way is to register one with the other so you can manage both in one place. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

|||

There is a DTS, it's just hidden (C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe).

Is there some documentation somewhere for how to do this register thing??

|||Try to add the BASEMENT\Guest account to the SQL logins on both SQL2000 and SQL Express.|||

I'm not using SQL2000. Both computers are on express...

|||

Sorry for misunderstanding, but you can try the same thing on both SQL Express. You can download Management Studio Express to manage your SQL Express Servers:

http://msdn.microsoft.com/vstudio/express/sql/download/

|||

Ya i have that already. I can see both SQL servers through that. But when i try to access the remote one i get a "login failed for user" error. They're both using Windows Authentication, perhaps this is a problem?

|||

I tracked down the detailed error message, not much more help:

"Valid login but server access failure"

|||

There is no DTS in Express a lot of needed components is not in Express, you could use the eval version of the full one then buy the developer edition it is under $40. Try the link below for a full comparison of all SQL Server editions. Hope this helps.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||

Ya it is, i'm using it as we speak.

Figured it out. Right click on the Management Studio (on the remote machine), right click on the database, pick permissions and grant them all to the public login. Not sure how secure this makes your database, but since it's just for testing anyway...

Friday, February 24, 2012

DTS.Package, where is it?

I created a DTS package, and saved it a as Visual Basic program.
But when I try to run it, it does not recognize DTS.Package, DTS.Package2.
Where can I find these?thanks for all your responses.

Wednesday, February 15, 2012

DTS to start a VB job on another server

When an entry is done on a table that has a trigger tied
to it, I would like to execute a Visual Basic program that
resides on another server. I tries making a DTS package
with the Execute Process task property. There is no
ability to pass a userid/password for a logon. I'm also
not sure, if this was even possible, would the program run
on that server or would is be pulled to the SQL Server and
actually run there?
Any info on if this is possible would be appreciated. If
there is some other method to allow an update to an entry
in the database trigger the running of the .exe on a
different server, that would be great to know.
TIA,
Doug
Try using the extended stored proc 'xp_cmdshell' to execute you exe...either map a drive to you sql server or provide the unc path.......
Brad Feaker
DBA
|||On the Win2k developement kit CD there is a file call exec.vbs which will
start a program on a remote server. The program will run in the remote
server's environment not the calling server. Use xp_cmdshell to start
exec.vbs.
"Brad Feaker" <anonymous@.discussions.microsoft.com> wrote in message
news:8B7FD9BF-8DBC-407E-B34C-44D82FBC5410@.microsoft.com...
> Try using the extended stored proc 'xp_cmdshell' to execute you
exe...either map a drive to you sql server or provide the unc path.......
> Brad Feaker
> DBA
>

DTS to start a VB job on another server

When an entry is done on a table that has a trigger tied
to it, I would like to execute a Visual Basic program that
resides on another server. I tries making a DTS package
with the Execute Process task property. There is no
ability to pass a userid/password for a logon. I'm also
not sure, if this was even possible, would the program run
on that server or would is be pulled to the SQL Server and
actually run there?
Any info on if this is possible would be appreciated. If
there is some other method to allow an update to an entry
in the database trigger the running of the .exe on a
different server, that would be great to know.
TIA,
DougTry using the extended stored proc 'xp_cmdshell' to execute you exe...eithe
r map a drive to you sql server or provide the unc path.......
Brad Feaker
DBA|||On the Win2k developement kit CD there is a file call exec.vbs which will
start a program on a remote server. The program will run in the remote
server's environment not the calling server. Use xp_cmdshell to start
exec.vbs.
"Brad Feaker" <anonymous@.discussions.microsoft.com> wrote in message
news:8B7FD9BF-8DBC-407E-B34C-44D82FBC5410@.microsoft.com...
> Try using the extended stored proc 'xp_cmdshell' to execute you
exe...either map a drive to you sql server or provide the unc path.......
> Brad Feaker
> DBA
>

DTS to start a VB job on another server

When an entry is done on a table that has a trigger tied
to it, I would like to execute a Visual Basic program that
resides on another server. I tries making a DTS package
with the Execute Process task property. There is no
ability to pass a userid/password for a logon. I'm also
not sure, if this was even possible, would the program run
on that server or would is be pulled to the SQL Server and
actually run there?
Any info on if this is possible would be appreciated. If
there is some other method to allow an update to an entry
in the database trigger the running of the .exe on a
different server, that would be great to know.
TIA,
DougTry using the extended stored proc 'xp_cmdshell' to execute you exe...either map a drive to you sql server or provide the unc path......
Brad Feake
DB|||On the Win2k developement kit CD there is a file call exec.vbs which will
start a program on a remote server. The program will run in the remote
server's environment not the calling server. Use xp_cmdshell to start
exec.vbs.
"Brad Feaker" <anonymous@.discussions.microsoft.com> wrote in message
news:8B7FD9BF-8DBC-407E-B34C-44D82FBC5410@.microsoft.com...
> Try using the extended stored proc 'xp_cmdshell' to execute you
exe...either map a drive to you sql server or provide the unc path.......
> Brad Feaker
> DBA
>

DTS that runs an .exe with UI requests

I am running an executable from a DTS paskage which opens a file with it's
associated program and saves it as another format. It works fine if I run i
t
manually but if I let the scheduled job try to run it, it hands and times
out. I believe this is because the program is trying to write to the displa
y
on the server and it can't even thought the code does not specify to display
the app. Is there a work-around for this? Should I specify in the code of
the exe a Windows login to run the program in? If so, how?
Much appreciated!
MattHi,
My experience is: the UI requirement is not the hurdle unlesss you let it
wait for a human to input something. Suggest to check file path setting, try
using UNC file path. Normally, when SQL Agent runs the program, it uses
another Windows account, so may not see the same drive mapping as those when
you run it manually.
James
"Matt Sonic" wrote:

> I am running an executable from a DTS paskage which opens a file with it's
> associated program and saves it as another format. It works fine if I run
it
> manually but if I let the scheduled job try to run it, it hands and times
> out. I believe this is because the program is trying to write to the disp
lay
> on the server and it can't even thought the code does not specify to displ
ay
> the app. Is there a work-around for this? Should I specify in the code o
f
> the exe a Windows login to run the program in? If so, how?
> Much appreciated!
> Matt|||Thanks James,
I use this string \\<IP Address>\<Folder>\<Folder>\<File Name.ext>
It works if I run the DTS Package but not the scheduled Job? The job runs
under my login and I can open the file from Windows Explorer.
"James Ma" wrote:
> Hi,
> My experience is: the UI requirement is not the hurdle unlesss you let it
> wait for a human to input something. Suggest to check file path setting, t
ry
> using UNC file path. Normally, when SQL Agent runs the program, it uses
> another Windows account, so may not see the same drive mapping as those wh
en
> you run it manually.
> James
> "Matt Sonic" wrote:
>|||What do you mean by "The job runs under my login"? I guess you just start th
e
job under your login, but that doesn't mean the SQL Agent will use your logi
n
to run the job. Can go to see SQLSERAGENT service's logon tab, that is the
login actually being used. Make sure that login can see and access to those
files and folders.
James
"Matt Sonic" wrote:
> Thanks James,
> I use this string \\<IP Address>\<Folder>\<Folder>\<File Name.ext>
> It works if I run the DTS Package but not the scheduled Job? The job runs
> under my login and I can open the file from Windows Explorer.
> "James Ma" wrote:
>|||The Owner of the job is MyDomain.MyUserName
Do you mean the Service Startup Account? 'SQLSERAGENT service's logon tab'
SQL Server Agent > Properties > General Tab...
"James Ma" wrote:
> What do you mean by "The job runs under my login"? I guess you just start
the
> job under your login, but that doesn't mean the SQL Agent will use your lo
gin
> to run the job. Can go to see SQLSERAGENT service's logon tab, that is the
> login actually being used. Make sure that login can see and access to thos
e
> files and folders.
> James
> "Matt Sonic" wrote:
>|||It doesn't use the owner's account. Yes, it uses SQLSERVERAGNET's service
startup account. I am using SQL Server 2000 here.
James
"Matt Sonic" wrote:
> The Owner of the job is MyDomain.MyUserName
> Do you mean the Service Startup Account? 'SQLSERAGENT service's logon tab
'
> SQL Server Agent > Properties > General Tab...
> "James Ma" wrote:
>|||BTW, you can try using RUNAS.exe tool to launch your application to simulate
your login.
"Matt Sonic" wrote:
> The Owner of the job is MyDomain.MyUserName
> Do you mean the Service Startup Account? 'SQLSERAGENT service's logon tab
'
> SQL Server Agent > Properties > General Tab...
> "James Ma" wrote:
>|||Still stuck. I can't use RUNAS.exe because it prompts for a password which
I
can't have because I want this to run on the server with no interaction from
users. I've got it to this point. The exe file runs but it does not open
the software it is codded to. This line fails.
Set objSEApp = CreateObject("SolidEdge.Application")
I use these two lines so it doesn't ping the UI
objSEApp.Visible = False
objSEApp.DisplayAlerts = False
The Service startup account is set to a specific account. Would there have
to be a Windows login created on the server for that account? I don't know
if servers have login acounts!
Thanks for the help!
"James Ma" wrote:
> BTW, you can try using RUNAS.exe tool to launch your application to simula
te
> your login.
> "Matt Sonic" wrote:
>