Running ACT! 2008 Database on two Laptops

Hi guys,
Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!
I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
my own (Vista) and the other is a company laptop. I can't synchronse using a
network connection between the two machines because the work laptop has all
manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
off that ACT! 2008 can only synchronise using a network connection. When I
bought ACT! 2008 I was told synchronisation is really simple. Can't use the
Internet sync as this is only available with ACT! for Workgroups.
I suddenly thought of the ideal solution; as I am the only user and I only
want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
and use that on either Laptop - very simple, convenient and actually even
easier than having to connect the two laptops to synchronise.
You guessed it - bloody problems, I can copy the Database onto the memory
stick and access it from the comuter that saved it.
If I try to open it from the OTHER Laptop I get an error message that I am
unable to open the database and to check my network connections, SQL Server
etc!!
Help, I'm going mad, there must surely be a simple solution to allow me to
transfer the Database backwards and forwards quickly between the two
machines using the memory stick?
Thanks in advance,
Best Regards,
Charles
Hi Charles
You don't say how you have restored the database on the second machine? My
guess is that the login you have created on the restoring machine is either
not present has been orphaned, and that is why you can not connect. You could
use SQL Profiler on the machine that works to see how it connects.
John
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>
|||Merge repl will give you grief and may cause app to fail. Merge adds a
rowguid column to each replicated table. Bi-directional trans repl will work
for you - but the admin overhead may cause headaches.
I've worked w/ act before - they finally have the db in sql which is a huge
improvement, but there is still some growing pains.
You really need to contact act support - or find an act consultant and have
heshe develop a customized solution for you.
Good Luck.
ChrisB MCDBA
MSSQLConsulting.com
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>

Running ACT! 2008 Database on two Laptops

Hi guys,
Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!
I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
my own (Vista) and the other is a company laptop. I can't synchronse using a
network connection between the two machines because the work laptop has all
manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
off that ACT! 2008 can only synchronise using a network connection. When I
bought ACT! 2008 I was told synchronisation is really simple. Can't use the
Internet sync as this is only available with ACT! for Workgroups.
I suddenly thought of the ideal solution; as I am the only user and I only
want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
and use that on either Laptop - very simple, convenient and actually even
easier than having to connect the two laptops to synchronise.
You guessed it - bloody problems, I can copy the Database onto the memory
stick and access it from the comuter that saved it.
If I try to open it from the OTHER Laptop I get an error message that I am
unable to open the database and to check my network connections, SQL Server
etc!!
Help, I'm going mad, there must surely be a simple solution to allow me to
transfer the Database backwards and forwards quickly between the two
machines using the memory stick?
Thanks in advance,
Best Regards,
Charles
Hi Charles
You don't say how you have restored the database on the second machine? My
guess is that the login you have created on the restoring machine is either
not present has been orphaned, and that is why you can not connect. You could
use SQL Profiler on the machine that works to see how it connects.
John
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>
|||Merge repl will give you grief and may cause app to fail. Merge adds a
rowguid column to each replicated table. Bi-directional trans repl will work
for you - but the admin overhead may cause headaches.
I've worked w/ act before - they finally have the db in sql which is a huge
improvement, but there is still some growing pains.
You really need to contact act support - or find an act consultant and have
heshe develop a customized solution for you.
Good Luck.
ChrisB MCDBA
MSSQLConsulting.com
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>

Running ACT! 2008 Database on two Laptops

Hi guys,
Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!
I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
my own (Vista) and the other is a company laptop. I can't synchronse using a
network connection between the two machines because the work laptop has all
manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
off that ACT! 2008 can only synchronise using a network connection. When I
bought ACT! 2008 I was told synchronisation is really simple. Can't use the
Internet sync as this is only available with ACT! for Workgroups.
I suddenly thought of the ideal solution; as I am the only user and I only
want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
and use that on either Laptop - very simple, convenient and actually even
easier than having to connect the two laptops to synchronise.
You guessed it - bloody problems, I can copy the Database onto the memory
stick and access it from the comuter that saved it.
If I try to open it from the OTHER Laptop I get an error message that I am
unable to open the database and to check my network connections, SQL Server
etc!!
Help, I'm going mad, there must surely be a simple solution to allow me to
transfer the Database backwards and forwards quickly between the two
machines using the memory stick?
Thanks in advance,
Best Regards,
CharlesHi Charles
You don't say how you have restored the database on the second machine? My
guess is that the login you have created on the restoring machine is either
not present has been orphaned, and that is why you can not connect. You coul
d
use SQL Profiler on the machine that works to see how it connects.
John
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one i
s
> my own (Vista) and the other is a company laptop. I can't synchronse using
a
> network connection between the two machines because the work laptop has al
l
> manner of hidden firewalls etc. so this is not an option. I'm really pi**e
d
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use th
e
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Sti
ck
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Serve
r
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>|||Merge repl will give you grief and may cause app to fail. Merge adds a
rowguid column to each replicated table. Bi-directional trans repl will work
for you - but the admin overhead may cause headaches.
I've worked w/ act before - they finally have the db in sql which is a huge
improvement, but there is still some growing pains.
You really need to contact act support - or find an act consultant and have
heshe develop a customized solution for you.
Good Luck.
ChrisB MCDBA
MSSQLConsulting.com
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one i
s
> my own (Vista) and the other is a company laptop. I can't synchronse using
a
> network connection between the two machines because the work laptop has al
l
> manner of hidden firewalls etc. so this is not an option. I'm really pi**e
d
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use th
e
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Sti
ck
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Serve
r
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>

Running ACT! 2008 Database on two Laptops

Hi guys,

Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!

I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
my own (Vista) and the other is a company laptop. I can't synchronse using a
network connection between the two machines because the work laptop has all
manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
off that ACT! 2008 can only synchronise using a network connection. When I
bought ACT! 2008 I was told synchronisation is really simple. Can't use the
Internet sync as this is only available with ACT! for Workgroups.

I suddenly thought of the ideal solution; as I am the only user and I only
want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
and use that on either Laptop - very simple, convenient and actually even
easier than having to connect the two laptops to synchronise.

You guessed it - bloody problems, I can copy the Database onto the memory
stick and access it from the comuter that saved it.

If I try to open it from the OTHER Laptop I get an error message that I am
unable to open the database and to check my network connections, SQL Server
etc!!

Help, I'm going mad, there must surely be a simple solution to allow me to
transfer the Database backwards and forwards quickly between the two
machines using the memory stick?

Thanks in advance,

Best Regards,

CharlesCharles Turner wrote:

Quote:

Originally Posted by

Hi guys,
>
Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!
>
I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one

Did you cross-post to enough groups? What do Postgres and MySQL have to do
with your question?

(followup set)

--
Lew|||I hate people like that -.-
Troll-by-ignorance...

Lew wrote:

Quote:

Originally Posted by

Charles Turner wrote:

Quote:

Originally Posted by

>Hi guys,
>>
>Hope some of you SQL database experts out there can help me, 'cos at
>the moment I'm going mad!
>>
>I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one

>
Did you cross-post to enough groups? What do Postgres and MySQL have to
do with your question?
>
(followup set)
>

sql

Running ACT! 2008 Database on two Laptops

Hi guys,
Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!
I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
my own (Vista) and the other is a company laptop. I can't synchronse using a
network connection between the two machines because the work laptop has all
manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
off that ACT! 2008 can only synchronise using a network connection. When I
bought ACT! 2008 I was told synchronisation is really simple. Can't use the
Internet sync as this is only available with ACT! for Workgroups.
I suddenly thought of the ideal solution; as I am the only user and I only
want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
and use that on either Laptop - very simple, convenient and actually even
easier than having to connect the two laptops to synchronise.
You guessed it - bloody problems, I can copy the Database onto the memory
stick and access it from the comuter that saved it.
If I try to open it from the OTHER Laptop I get an error message that I am
unable to open the database and to check my network connections, SQL Server
etc!!
Help, I'm going mad, there must surely be a simple solution to allow me to
transfer the Database backwards and forwards quickly between the two
machines using the memory stick?
Thanks in advance,
Best Regards,
Charles
Hi Charles
You don't say how you have restored the database on the second machine? My
guess is that the login you have created on the restoring machine is either
not present has been orphaned, and that is why you can not connect. You could
use SQL Profiler on the machine that works to see how it connects.
John
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>
|||Merge repl will give you grief and may cause app to fail. Merge adds a
rowguid column to each replicated table. Bi-directional trans repl will work
for you - but the admin overhead may cause headaches.
I've worked w/ act before - they finally have the db in sql which is a huge
improvement, but there is still some growing pains.
You really need to contact act support - or find an act consultant and have
heshe develop a customized solution for you.
Good Luck.
ChrisB MCDBA
MSSQLConsulting.com
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>

Running ACT! 2008 Database on two Laptops

Hi guys,
Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!
I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
my own (Vista) and the other is a company laptop. I can't synchronse using a
network connection between the two machines because the work laptop has all
manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
off that ACT! 2008 can only synchronise using a network connection. When I
bought ACT! 2008 I was told synchronisation is really simple. Can't use the
Internet sync as this is only available with ACT! for Workgroups.
I suddenly thought of the ideal solution; as I am the only user and I only
want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
and use that on either Laptop - very simple, convenient and actually even
easier than having to connect the two laptops to synchronise.
You guessed it - bloody problems, I can copy the Database onto the memory
stick and access it from the comuter that saved it.
If I try to open it from the OTHER Laptop I get an error message that I am
unable to open the database and to check my network connections, SQL Server
etc!!
Help, I'm going mad, there must surely be a simple solution to allow me to
transfer the Database backwards and forwards quickly between the two
machines using the memory stick?
Thanks in advance,
Best Regards,
CharlesHi Charles
You don't say how you have restored the database on the second machine? My
guess is that the login you have created on the restoring machine is either
not present has been orphaned, and that is why you can not connect. You could
use SQL Profiler on the machine that works to see how it connects.
John
"Charles Turner" wrote:
> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>|||Merge repl will give you grief and may cause app to fail. Merge adds a
rowguid column to each replicated table. Bi-directional trans repl will work
for you - but the admin overhead may cause headaches.
I've worked w/ act before - they finally have the db in sql which is a huge
improvement, but there is still some growing pains.
You really need to contact act support - or find an act consultant and have
heshe develop a customized solution for you.
Good Luck.
ChrisB MCDBA
MSSQLConsulting.com
"Charles Turner" wrote:
> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>

Running a Stored procedure or a query

Hi Guys
I woud like to run either a stored procedure before runing the actual
report. The stored procedure will create and update a table and on the second
run the report query will run and produce the report.
Is it possible to achieve this?
Regards
Tofigh> I woud like to run either a stored procedure before runing the actual
> report. The stored procedure will create and update a table and on the
second
> run the report query will run and produce the report.
> Is it possible to achieve this?
I guess your report is scheduled. Just edit the scheduled job and insert a
step that executes the stored procedures before the step that causes the
report to run.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Thanks for the reply, the report is not scheduled. the users will run the
report on demand.
Regards
Tofigh
"Dejan Sarka" wrote:
> > I woud like to run either a stored procedure before runing the actual
> > report. The stored procedure will create and update a table and on the
> second
> > run the report query will run and produce the report.
> >
> > Is it possible to achieve this?
> I guess your report is scheduled. Just edit the scheduled job and insert a
> step that executes the stored procedures before the step that causes the
> report to run.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>|||Then maybe you can use two SPs - one outer that is called from the report
and returns the data, and inside it you first make a call to the second
procedure that prepares the tables.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"TA" <TA@.discussions.microsoft.com> wrote in message
news:9C1789C5-6FF7-469B-888A-6B0E7547F2BA@.microsoft.com...
> Thanks for the reply, the report is not scheduled. the users will run the
> report on demand.
> Regards
> Tofigh
> "Dejan Sarka" wrote:
> > > I woud like to run either a stored procedure before runing the actual
> > > report. The stored procedure will create and update a table and on the
> > second
> > > run the report query will run and produce the report.
> > >
> > > Is it possible to achieve this?
> >
> > I guess your report is scheduled. Just edit the scheduled job and insert
a
> > step that executes the stored procedures before the step that causes the
> > report to run.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > www.SolidQualityLearning.com
> >
> >
> >

Run SQL-Server Query in Excel

Hi guys,
is there a way to run a SQL-query on a SQL-Server
within Excel?
(Is it possible to create any JOIN-querys and DATEDIFF-functions within
Excel-Microsoft Query?)
Thanks much guys,
Mike
Yes, is possible.
1. Start to record Macro.
2. Data > Import External Data > New Database Query .. > ...... > and so
on ..(Build a simple query and rerturn data to Excel)
3. Stop record Macro and Edit . You can change your query and run Macro
whenever you want.
"Maik Richter" <maik.richter2@.gmx.de> wrote in message
news:%23XeAJjvcEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Hi guys,
> is there a way to run a SQL-query on a SQL-Server
> within Excel?
> (Is it possible to create any JOIN-querys and DATEDIFF-functions within
> Excel-Microsoft Query?)
> Thanks much guys,
> Mike
>

Run SQL-Server Query in Excel

Hi guys,
is there a way to run a SQL-query on a SQL-Server
within Excel?
(Is it possible to create any JOIN-querys and DATEDIFF-functions within
Excel-Microsoft Query?)
Thanks much guys,
MikeYes, is possible.
1. Start to record Macro.
2. Data > Import External Data > New Database Query .. > ...... > and so
on ..(Build a simple query and rerturn data to Excel)
3. Stop record Macro and Edit . You can change your query and run Macro
whenever you want.
"Maik Richter" <maik.richter2@.gmx.de> wrote in message
news:%23XeAJjvcEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Hi guys,
> is there a way to run a SQL-query on a SQL-Server
> within Excel?
> (Is it possible to create any JOIN-querys and DATEDIFF-functions within
> Excel-Microsoft Query?)
> Thanks much guys,
> Mike
>

Run Faster

Hi Guys,
I have SQL file but it run slowly when comes to huge record. How do I make it faster. I do create an index but how to make use the index? Pls help me on this...
Many Thanks,
Regards,
Shaffiqpost the query.let us see ur query :D|||I running it on Coldfusion program :

SELECT ID,
ORDERREFERENCE,
CUSTOMER,
TRANSACTIONTYPE,
FIRSTNAME,
LASTNAME,
COMPANY,
ADDRESS,
CITY,
STATE,
ZIP,
COUNTRY,
EMAIL,
PHONE,
SHIPFIRSTNAME,
SHIPLASTNAME,
SHIPADDRESS,
SHIPCITY,
SHIPSTATE,
SHIPZIP,
SHIPCOUNTRY,
COMMENT1,
COMMENT2
FROM GTRANSACTIONRECORD
WHERE 0 = 0



AND TRANSACTIONDATETIME BETWEEN <CFQUERYPARAM VALUE="2005-02-17 00:00:00" CFSQLTYPE="CF_SQL_DATE">
AND <CFQUERYPARAM VALUE="2005-02-18 00:00:00" CFSQLTYPE="CF_SQL_DATE">


ORDER BY ORDERREFERENCE ASC|||you do not need the "0 = 0" and I would try creating a nonclustered index on TRANSACTIONDATETIME.|||Yeah, drop the 0=0, though that is not what is causing the query to run slowly.
Do you have indexes on TRANSACTIONDATETIME and ORDERREFERENCE?
Do you absolutely need the ORDER BY clause? I'm guessing that is where the slowdown is occuring, and recordset ordering is usually a presentation issue that should be handled by the interface or reporting tool.

Have you tried running this code in Query Analyzer with the SHOW EXECUTION PLAN option set?|||I think he using '0=0' for constructing where clause dynamically in application,so he dont have to check whether its first filter case or second case.|||That would be my guess too, or it was left behind by a previous coder...

Run Barch in SQL Server problem - share drive??

Hello Guys,
I have a problem with a job moving and zipping file to share drive
What does my Batch?
1) Copy backup device (initially in D:/) into
//SERVER/SHARE/Archived_Backups/
2) Create new folder in //SERVER/SHARE/Archived_Backups/
3) Move the DEVICE into this new folder
4) Zip the DEVICE and named it today.zip
if I run it manually the batch file works perfectly, But if I launch it
with sql server (what I would like to perform) this step does not run
perfectly.
What does this job?
1) run the batch
Step 1
DECLARE @.cmd sysname, @.var sysname
SET @.var = 'start D:\Backups\MyBacth.bat'
EXEC master..xp_cmdshell @.var
2) Overwrite the DEVICE
3) Verify DEVICE integrity
I have already set privileges for sqlservice in to this share
What do i need to do? Any Suggestions?
Thanks in advance
InaSorry,
Thank you for your answer... yes it is running and has network
privileges.
Regards,
Ina
John Bell wrote:
> Hi
> Apart from the typo in your script! You don't say what the SQL Agent account
> is running as and if it has network privileges.
> John
> "ina" wrote:
> > Hello Guys,
> >
> > I have a problem with a job moving and zipping file to share drive
> >
> >
> > What does my Batch?
> >
> >
> >
> > 1) Copy backup device (initially in D:/) into
> > //SERVER/SHARE/Archived_Backups/
> >
> > 2) Create new folder in //SERVER/SHARE/Archived_Backups/
> >
> > 3) Move the DEVICE into this new folder
> >
> > 4) Zip the DEVICE and named it today.zip
> >
> >
> > if I run it manually the batch file works perfectly, But if I launch it
> > with sql server (what I would like to perform) this step does not run
> > perfectly.
> >
> > What does this job?
> >
> > 1) run the batch
> > Step 1
> > DECLARE @.cmd sysname, @.var sysname
> > SET @.var = 'start D:\Backups\MyBacth.bat'
> > EXEC master..xp_cmdshell @.var
> >
> > 2) Overwrite the DEVICE
> >
> > 3) Verify DEVICE integrity
> >
> >
> > I have already set privileges for sqlservice in to this share
> >
> >
> > What do i need to do? Any Suggestions?
> >
> >
> > Thanks in advance
> >
> >
> >
> > Ina
> >
> >|||Hi Ina
Does this mean that you have solved the problem? If not can you log onto the
server as the service account and run the job?
John
"ina" wrote:
> Sorry,
> Thank you for your answer... yes it is running and has network
> privileges.
> Regards,
> Ina
>
> John Bell wrote:
> > Hi
> >
> > Apart from the typo in your script! You don't say what the SQL Agent account
> > is running as and if it has network privileges.
> >
> > John
> >
> > "ina" wrote:
> >
> > > Hello Guys,
> > >
> > > I have a problem with a job moving and zipping file to share drive
> > >
> > >
> > > What does my Batch?
> > >
> > >
> > >
> > > 1) Copy backup device (initially in D:/) into
> > > //SERVER/SHARE/Archived_Backups/
> > >
> > > 2) Create new folder in //SERVER/SHARE/Archived_Backups/
> > >
> > > 3) Move the DEVICE into this new folder
> > >
> > > 4) Zip the DEVICE and named it today.zip
> > >
> > >
> > > if I run it manually the batch file works perfectly, But if I launch it
> > > with sql server (what I would like to perform) this step does not run
> > > perfectly.
> > >
> > > What does this job?
> > >
> > > 1) run the batch
> > > Step 1
> > > DECLARE @.cmd sysname, @.var sysname
> > > SET @.var = 'start D:\Backups\MyBacth.bat'
> > > EXEC master..xp_cmdshell @.var
> > >
> > > 2) Overwrite the DEVICE
> > >
> > > 3) Verify DEVICE integrity
> > >
> > >
> > > I have already set privileges for sqlservice in to this share
> > >
> > >
> > > What do i need to do? Any Suggestions?
> > >
> > >
> > > Thanks in advance
> > >
> > >
> > >
> > > Ina
> > >
> > >
>|||Hello Jonh I was in holidays,
Happy new 2007!!!
I did not solved the problem. my sqlservice has network privileges but
I cannot run this job. So, I did a scheduled task for copy and zip the
backup and run a job to overwrite the existing backup.
I have three disk configurate with my slq server (C --> local, D -->
Data and F --> backup) how can I set up a new one without restall sql
Server again.
Best regards,
Ina
John Bell wrote:
> Hi Ina
> Does this mean that you have solved the problem? If not can you log onto the
> server as the service account and run the job?
> John
> "ina" wrote:
> > Sorry,
> >
> > Thank you for your answer... yes it is running and has network
> > privileges.
> >
> > Regards,
> >
> > Ina
> >
> >
> > John Bell wrote:
> > > Hi
> > >
> > > Apart from the typo in your script! You don't say what the SQL Agent account
> > > is running as and if it has network privileges.
> > >
> > > John
> > >
> > > "ina" wrote:
> > >
> > > > Hello Guys,
> > > >
> > > > I have a problem with a job moving and zipping file to share drive
> > > >
> > > >
> > > > What does my Batch?
> > > >
> > > >
> > > >
> > > > 1) Copy backup device (initially in D:/) into
> > > > //SERVER/SHARE/Archived_Backups/
> > > >
> > > > 2) Create new folder in //SERVER/SHARE/Archived_Backups/
> > > >
> > > > 3) Move the DEVICE into this new folder
> > > >
> > > > 4) Zip the DEVICE and named it today.zip
> > > >
> > > >
> > > > if I run it manually the batch file works perfectly, But if I launch it
> > > > with sql server (what I would like to perform) this step does not run
> > > > perfectly.
> > > >
> > > > What does this job?
> > > >
> > > > 1) run the batch
> > > > Step 1
> > > > DECLARE @.cmd sysname, @.var sysname
> > > > SET @.var = 'start D:\Backups\MyBacth.bat'
> > > > EXEC master..xp_cmdshell @.var
> > > >
> > > > 2) Overwrite the DEVICE
> > > >
> > > > 3) Verify DEVICE integrity
> > > >
> > > >
> > > > I have already set privileges for sqlservice in to this share
> > > >
> > > >
> > > > What do i need to do? Any Suggestions?
> > > >
> > > >
> > > > Thanks in advance
> > > >
> > > >
> > > >
> > > > Ina
> > > >
> > > >
> >
> >|||John Thank you for this tips.
I will try to do that.
Ina
John Bell wrote:
> Hi Ina
> Happy New Year!
> Looking back at your script, can you change the batch file it so that does
> not map the network drive, zips up the backup file before it copies it to the
> UNC? On the extended properties for the step can you then add a log file so
> that any error messages are captured. Then schedule the job to run and post
> the messages from the log file.
> Thanks
> John
>
> "ina" wrote:
> > Hello Jonh I was in holidays,
> >
> > Happy new 2007!!!
> >
> > I did not solved the problem. my sqlservice has network privileges but
> > I cannot run this job. So, I did a scheduled task for copy and zip the
> > backup and run a job to overwrite the existing backup.
> >
> > I have three disk configurate with my slq server (C --> local, D -->
> > Data and F --> backup) how can I set up a new one without restall sql
> > Server again.
> >
> > Best regards,
> >
> > Ina
> >
> > John Bell wrote:
> > > Hi Ina
> > >
> > > Does this mean that you have solved the problem? If not can you log onto the
> > > server as the service account and run the job?
> > >
> > > John
> > >
> > > "ina" wrote:
> > >
> > > > Sorry,
> > > >
> > > > Thank you for your answer... yes it is running and has network
> > > > privileges.
> > > >
> > > > Regards,
> > > >
> > > > Ina
> > > >
> > > >
> > > > John Bell wrote:
> > > > > Hi
> > > > >
> > > > > Apart from the typo in your script! You don't say what the SQL Agent account
> > > > > is running as and if it has network privileges.
> > > > >
> > > > > John
> > > > >
> > > > > "ina" wrote:
> > > > >
> > > > > > Hello Guys,
> > > > > >
> > > > > > I have a problem with a job moving and zipping file to share drive
> > > > > >
> > > > > >
> > > > > > What does my Batch?
> > > > > >
> > > > > >
> > > > > >
> > > > > > 1) Copy backup device (initially in D:/) into
> > > > > > //SERVER/SHARE/Archived_Backups/
> > > > > >
> > > > > > 2) Create new folder in //SERVER/SHARE/Archived_Backups/
> > > > > >
> > > > > > 3) Move the DEVICE into this new folder
> > > > > >
> > > > > > 4) Zip the DEVICE and named it today.zip
> > > > > >
> > > > > >
> > > > > > if I run it manually the batch file works perfectly, But if I launch it
> > > > > > with sql server (what I would like to perform) this step does not run
> > > > > > perfectly.
> > > > > >
> > > > > > What does this job?
> > > > > >
> > > > > > 1) run the batch
> > > > > > Step 1
> > > > > > DECLARE @.cmd sysname, @.var sysname
> > > > > > SET @.var = 'start D:\Backups\MyBacth.bat'
> > > > > > EXEC master..xp_cmdshell @.var
> > > > > >
> > > > > > 2) Overwrite the DEVICE
> > > > > >
> > > > > > 3) Verify DEVICE integrity
> > > > > >
> > > > > >
> > > > > > I have already set privileges for sqlservice in to this share
> > > > > >
> > > > > >
> > > > > > What do i need to do? Any Suggestions?
> > > > > >
> > > > > >
> > > > > > Thanks in advance
> > > > > >
> > > > > >
> > > > > >
> > > > > > Ina
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >