Running ACT! 2008 Database On Two Laptops
Nov 3, 2007
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
View 2 Replies
ADVERTISEMENT
Jun 15, 2015
How can we get most frequent queries that are running against to a table in our database?
View 3 Replies
View Related
Apr 30, 2015
Whenever I'm running query against the below database alone, it throws me the error.
use [AdventureWorks_2005]
SELECT * FROM dbo.sysFILES
OR
SELECT * FROM [AdventureWorks_2005].[sys].[SYSFILES]
Error- >
Msg 208, Level 16, State 1, Line 2
Invalid object name 'dbo.sysFILES'
View 3 Replies
View Related
Mar 30, 2001
WE have a production database that we need to sync with about 100
salesman's laptops. These laptops will not always be online and
would need to sync on the fly.
We are thinking of having a separate distribution database to handle
the load and creating either a pull subscription or even just a DTS
package. We would like to have the salesmen just signon and go to an
ASP page and hit an Icon and either the pull subscription or the dts
package would start the sync..
Anyone tried this before and have any other ideas??
Thanks for any help??
SB
View 2 Replies
View Related
Mar 10, 2006
I need advice of a powerfull laptop can bear the future extensions ofOracle editions and implementing installations of all Oracle productson it ?
View 3 Replies
View Related
Sep 5, 2006
I am installing SQL 2005 Express on several laptops (IBM Thinkpads and Dell latitudes) and I've noticed that doing the exact came configuration options with the exact same file, the IBM thinkpads just take the Machine name for SQL Server, while the Dells take MachinenameSQLEXPRESS. I am wondering how I can get it to just take the machine name on the Dells.
Thanks a lot
View 2 Replies
View Related
May 28, 2015
In my environment, there is maintenance plan configured on one of the server and while running DBCC checkdb on a database of size around 200GB, log file usage of tempdb is increasing and causing the maintenance job to fail.
What can I do to make the maintenance job run successfully, size of the tempdb database is only 50GB and recovery model is set to simple. It cannot be increased as the mount point on which it is residing is 50GB.
View 3 Replies
View Related
Nov 20, 2015
Is it possible to assign to a variable, then add to it later on? When I run the below, all I get is 3 rows affected I never see the value printed. What i am wanting to do is each loop sum the numbers so 2+1+3 =6 so in the end @sumofallnumbers
= 6
Create Table #Test ( randarnumbers int )
Insert Into #Test Values ('2'), ('1'), ('3')
Declare @sumofallnumbers int, @nbr int
Declare c1 Cursor For
Select randarnumbers
FROM #Test
[code]..
View 6 Replies
View Related
May 13, 2015
When trying to open the log shipping status report, I get an error: user must be in the master database. The jobs appear to be running correctly.
View 0 Replies
View Related
Aug 6, 2015
In my requirement,My production server running more then 5 jobs . I want details in running schedule in minutes. For example
1) First Job
I am configured every one hour.
2) Second job
Configured in every 30 min
3) Third job
Configured every 60 min
4) Fourth Job
Configured every 24 hrs
I want the result
SNOJOBNameRunning Schedule(in Min)
1First JOB 60min
2Second JOB 30 min
3Third JOB 60min
4Fourth JOB 1440min
View 1 Replies
View Related
Oct 3, 2015
i just kicked off a job that starts a data driven subscription that generates ~200 excel spreadsheets.
I kind of expected them to appear in the execution log, and that the TimeEnd would reflect when they complete.
instead, it appears that the TimeEnd is when the SQLcommand finished executing, ie, a few milliseconds after the start.
it does not reflect when the report finishes completing; if i run sp_whoisactive, i see a stack of reports at a time clawing their way through the process. (ie i see calls to [CreateChunkStatement] and all the other steps a report kicks off.
Other than watching execution requests, how can i know if anything is running as far as subscriptions go?
View 0 Replies
View Related
May 29, 2013
When I give job Id in filter of this query this will give job status of "Success" but actually my job is currently in executing stage. I want to get all jobs that are currently in executing status.
Use msdb
go
select distinct j.Name as "Job Name", --j.job_id,
case j.enabled
when 1 then 'Enable'
when 0 then 'Disable'
[Code] ....
View 4 Replies
View Related
Apr 29, 2015
I'm trying to call WinSCP in a SSIS Execute Process Task using a .bat file to automate. SSIS is returning a generic failure error message ("Error: 0xC0029151 at Execute Process Task, Execute Process Task: In Executing "MyServerC$Program Files (x86)WinSCPWinSCP.exe" "-script=MyNASShareWinSCPFTP.bat " at "", The process exit code was "1" while the expected was "0"."). So now I'm trying to run the .bat file by itself. Unfortunately, the command prompt rushes by so fast that I can't see what the server is doing.
I can't find anything on the WinSCP site that indicates how to slow down the .bat file processing or log the remote server responses. I do see how to use the /log switch when using the interactive command line console, but that's not what I want to do.
View 9 Replies
View Related
Jul 23, 2015
Without going to services.msc / configuration manager, is there anyway to know the service account through which SQL server is running?
View 6 Replies
View Related
Aug 6, 2015
I have a balance sheet report developed and working. What I need to do is add the ability to click (or double-click) on a number and have a separate report (drill-down) open with the detail that makes up that number. I've researched drill-through reports, sub reports, etc. but can't find a way to do what I want.
I'm now thinking that I need to add custom code in the report properties, code window to do this. I'm hoping that there is a VB method I can use to call this report and pass a parameter. Pseudo-code for this function would look something like this: RunReport("DrillDownReport", "Parameter").
This seems like it should be pretty easy but I don't know what the function is in VB for running an SSRS report (if there is one).
Is this possible or am I barking up the wrong code tree?
View 5 Replies
View Related
Sep 1, 2015
We are receiving following alerts frequently about 1:40 AM in the morning. We have backups running on 11:00 PM everyday and rebuild job running at 2:00 AM. Not sure the exact cause of this error.
Error:
The file group "PRIMARY" for the database "tempdb" in SQL instance "MSSQLSERVER" on computer "XYZ" is running out of space.
tempdev Initial size : 133,100 MB Growth: By 10 percent, Limited to 140000 MB
templog Initial Size : 5,475 MB Growth: By 10 percent, Unlimited
View 9 Replies
View Related
May 11, 2015
I have create a batch file to execute a stored proc to import data.
When I run it from the server (Remote Desktop) it works fine, but if I share the folder and try to run it from my pc, it doesn't do anything. I don't get an error, it just doesn't do anything. My windows user has admin rights in SQL. Why is it not executing from my PC?
View 9 Replies
View Related
Aug 27, 2015
I made one report in SSRS 2008 in which getting data from one SharePoint List.
three parameters in report :
Country
StartDate
EndDate
I am using query which I created with CAML.
query is running well and data is coming correctly if I run this on Query designer.and date format must be YYYY-MM-DD.but when I try to run through on run time then the date control is showing format dd/mm/yyyy.
I change the regional settings of windows and SharePoint site to English(United States). and when I select date control it is also putting date in format like "YYYY-MM-DD'. and in that format report is working well in Query designer view.But on run time still it is not working.
View 3 Replies
View Related
Feb 18, 2015
SQL Server 2008 r2 - 6 GB memory...I attempted a backup on a 500GB database but it was taking way too long. I checked the resources on the box and saw the CPU at 100%. I checked the SQL Server activity log and saw a hung query (user was not even logged on) that had multiple threads so I killed it and now the CPU utilization is back to normal.
Trouble is, now all of the threads in the activity monitor for the backup show 'suspended' and the backup appears to be not doing anything.
View 3 Replies
View Related
Jan 21, 2008
Hello!
I was wondering if I can install/run SQL 2008 and 2005 side by side with SQL 2005 being default instance. Any issues with that?
Thanks,
Igor
View 2 Replies
View Related
Jan 5, 2007
I am construvcting a number of databases, some of which containsensitive data and most of which do not. I am attempting to handle thesecurity issues involved in protecting sensitive data in part byputting it in its own database. If the sensitive data is in a databasecalled d_SensitiveData, and in that database there is a table called't_A' (I know, not very informative, but this is only a triviallysimple example :-), and I have a script running in a database'NotSensitiveData' (i.e. there is a statement at the beginning of thescript "USE NotSensitiveData"), how do I referenece the primary key intable 'A'?I tried a variety of things like:ALTER TABLE t_nsXADD CONSTRAINT FK_PersonID FOREIGN KEY (p_idPerson)REFERENCES SensitiveData.t_A (p_idPerson);The above is, in fact, my latest attempt. Everything I tried hasfailed precisely at the point where I specify a table in a differentdatabase. So what is the trick to refering to a table in one databasewhen using another database?This will be used in a ASP.NET v3 application where one of the things Iwant to do is have the authentication provider be a different databasefrom the one used for the main application data.Does anyone know of an example I can download from the web that doesthe same sort of thing I want to try, with some discussion of securityissues involved (i.e. what I can do to harden the application and dataserver)?NB: I am an application developer, not a DBA nor a systemadministrator.ThanksTed
View 6 Replies
View Related
Mar 8, 2015
I had to to relocate the database log file and I issued an Alter database command but by mistake I put a space in the file name as below. The space is at the beginning file name. Now I am unable get the database loaded to SQL Server. The database has 2 replications configured, so deleting and re-attaching the database means the replication needs to be re-configured. Is there an alternative way to issue a command to update the database FILENAME ? Not sure if this can be edited in master database (sys files).
ALTER DATABASE [User_DB]
MODIFY FILE (NAME = User_DB_log, FILENAME = 'I:SQLLogs User_DB_log.ldf')
GO
View 1 Replies
View Related
Aug 4, 2015
I found this script online..
SELECT prin.[name] [User], sec.state_desc + ' ' + sec.permission_name [Permission]
FROM [sys].[database_permissions] sec
JOIN [sys].[database_principals] prin
ON sec.[grantee_principal_id] = prin.[principal_id]
WHERE sec.class = 0
ORDER BY [User], [Permission];
but the results are this: 2 columns - User and Permission
User Permission
User1 GRANT CONNECT
User2 GRANT CONNECT
IS there a way in SQL Server (2005/2008/2012) to run a script against a Database that will show all users that have permissions to that Database and the type of permissions?
View 7 Replies
View Related
Aug 7, 2007
Hello all-I need to check to see if the database is running before I begin all sorts of processing and figured I would do something like this. Any better ways to do this? I want to check to see if the db is up and running and also check to make sure I can connect to it.
Private Function DatabaseRunning() As Boolean
'Checks to see if the database is up and running.Dim objDataConnection As SqlConnection = New SqlConnection(ConnectionString)
Try
objDataConnection.Open()Catch ex As Exception
Return False
End Try
objDataConnection.Close()
Return True
End Function
View 3 Replies
View Related
Jun 2, 2005
How often should I run statistics on a database and what should I use? The create statistics function? Right now we have not run statistics against the database in over 8 months. However, we do have the database setup so that it will autocreate and auto update statistics on each table. Is this the best way to keep statistics up to date or is it better to run a function that rebuilds them on a nightly/weekly basis. Our database does have a large amount of activity against 99% of it takes place between 7am-6pm so the rest of the day/night we have open to schedule things like this. Any suggestions? I am really just trying to get a handle on the best way to keep our database running smoothly and quickly.
View 2 Replies
View Related
Mar 4, 2008
Hi,
Currently I have a Report Model that uses a Data Source where the "Credentials are supplied by the user running the report". This works quite well.
The only further requirement is that I would also like to be able to specify which database to use (at runtime), would this be possible?
Kind Regards,
Robert
View 3 Replies
View Related
Jan 11, 2002
Hi, I have the following error logged in SQL Server's error log whenever I run a query on a particular database :
2002-01-04 22:54:02.46 spid11 Error: 823, Severity: 24, State: 1 2002-01-04 22:54:02.46 spid11 I/O error 1117(The request could not be performed because of an I/O device error.) detected during read of BUF pointer = 0x14eac480, page ptr = 0x73c94000, pageid = (0x1:0x158c89), dbid = 8, status = 0x801, file = d:mssql7datamydb.mdf..
2002-01-05 05:54:22.01 kernel SQL Server terminating because of system shutdown. 2002-01-05 05:54:22.14 kernel LogEvent: Failed to report the current event. Operating system error = 31(A device attached to the system is not functioning.).
and get this error in the Results pane of Query analyzer : Server: Msg 823, Level 24, State 1, Line 1 I/O error 1117(The request could not be performed because of an I/O device error.) detected during read of BUF pointer = 0x14ace4c0, page ptr = 0x35df6000, pageid = (0x1:0x44b73), dbid = 14, status = 0x801, file = d:MSSQL7DATAmydb.mdf.
Connection Broken
select @@version returns, Microsoft SQL Server 7.00 - 7.00.961 (Intel X86) Oct 24 2000 18:39:12 Copyright (c) 1988-1998 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Books Online Help on Error 823 indicates that it is a disk problem and suggests that DBCC checkdb needs to be run on the database. But, hardware diagnostics on the server do not report any disk problems and dbcc checkdb also returns no errors.
Help on the cause of error 823 would be greatly appreciated. Thank you, Praveena
View 1 Replies
View Related
Aug 28, 2001
I have a question on database size, specifically, what difference would I expect in the size of a db (the space actually used for data, not indexes) if I have one single data device vs. multiple data devices spanned across different physical drives. I have 2 customers that have identical database tables (all columns are integers), customer A has 27 million rows and customer B has 36 million rows. If I do an sp_spaceused on the table, customer A's data takes up 9.7 gig, whereas customer B only takes up 3.2 gig, even though it has 9 million more rows. Statistics have been updated, so I'm confident the sp_spaceused is accurate on both databases.
The only differences I can see between the 2 databases is that customer B has 5 separate data files (6 gig each) for the database which are part of the Primary filegroup. These files are all on the D: drive, which is a partition on a RAID 5 array. Customer A has a single large data file (24 gig), which is also on a RAID 5 array.
Any ideas?
View 4 Replies
View Related
Aug 7, 2006
First post here, hi to everyone.
Is it possible to update rows in a table while users are working on that table or do I have to throw them out? Thanks for the help!
View 1 Replies
View Related
May 28, 2008
I have just installed sql server 2005 express, and ssmse..
have created the db, and can work in the management studio writing queries,etc.. all is fine..
when i try to open my proprietary exe i get the error of
"SQL SERVER NOT RUNNING OR DATABASE CANNOT BE FOUND" Now, I know the DB is there, and I know SQL is runnig.. what could it be?
any ideas and thanks in advance..
View 10 Replies
View Related
Jan 24, 2008
Hi,
I had application that access the database 'test'. Now i created a ETL package, in this Souce database is 'test' and destination database is 'mytest'. I have scheduled the job for every hour.
Now, i want to know that whether any locks will create on source database 'test' while ETL package is running.
Thanks
Dinesh
View 5 Replies
View Related
Apr 11, 2008
Hi,
I searched in the previous posting but can't find any or miss them. We have a few databases that users can run reports from, i.e. production, training & development. Is there any way, say put it in either in the header or footer, to display from which database that the report are running from? Sometimes they got confused whether the data is current or like few days old.
Any input is very much appreciated. Thanks in advance ..
View 5 Replies
View Related
May 6, 2008
hi my local host cannot open the connection to my database, whilst testing with vwd seems to be able to do this? other server side functions work (response.write("hello world"))
in my iis the version of .net it says its running reads: 2.0.50727, though when i go to add / remove programmes i have 3.5 there? maybe its nothing to do with .net versions?
thanks in advance for your help
pete
View 5 Replies
View Related
