as far as the backward compatibility is concerned , how can i differentiate the ms access and sql server , on the basis of this feature?
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
Does any one know how I would get some data from a MsSQL database and upload it to MySQL hosted server
I’m running Symantec backup exec on a few severs and they email me notifications of what’s happened in the back up but there are too many to start filling away!!! The program uses MsSql to store the information I want to upload it to mysql hosted sever. I can tell backup exec to run a command after backup
“If we are all in agreement on the decision - then I propose we postpone further discussion of this matter until our next meeting to give ourselves time to develop disagreement and perhaps gain some understanding of what the decision is all about.”-Alfred P. Sloan
Do you mean you want to move the data files for an existing database to a different location?
Detach the database (right-click it in Management Studio or Enterprise Manager and click Detach), make a note of the security settings on the files, move them, check that the same users have permission to read and write the files, and then re-attach the database (this option is named Attach on the server's context menu).
DoEvents: Generating unexpected recursion since 1991
How can i configure my Sql Server2005 to communicate with MSAccess which is locating on some other place(Other city). I want to update the Sql server with the updated information of MSAccess tables as they both come online. Please guide me to setup this confuguration.
Thanks in advance
I have found a potential problem which may get some people stuck when they have customised their Regional Settings. Too short to submit as an Article. Moderators please do with it what is best.
I live in South Africa. PC set up for English (South Africa).
The problem is, Microsoft says that in South Africa we write our dates as MM/dd/yyyy, when in fact we (ordinary people) use dd/MM/yyyy.
So in Reqional Settings we use Customise and change our Short Date format to dd/MM/yyyy.
Everything works fine if you use datasets to update a table, as the data is already a DateTime. But when you use an INSERT INTO command a problem comes up because the DateTime needs to be placed between single-quotes:
"INSERT INTO (column) VALUES('" + myDate + "')"
In our case, this converts to:
"INSERT INTO (column) VALUES('dd/MM/yyyy')"
But the server is expecting:
"INSERT INTO (column) VALUES('MM/dd/yyyy')" because this is the default short-date format for South Africa.
So the following must be used:
"INSERT INTO (column) VALUES('" + myDate.ToString("MM/dd/yyyy") + "')"
This converts to:
"INSERT INTO (column) VALUES('MM/dd/yyyy')" which is what the server is expecting.
This problem will arise with any Customisations made, including separators. myDate.ToString() must specify the exact format the server is expecting.
If needing to parse in date information like that (and you can't use parameterized as suggested by the previous poster), use the ISO format and it should be okay on all regional settings.
Of course there'll be problems if the regional settings are different from what you feed any conversion with. How else do you think it should know whether the date 04/05/2008 means either 4th May or 5th April. How else will you know whether numbers use decimal point period or comma etc.
That is the "problem" with conversions between regions.
i have develping an application in vb.net with mssql express 2005,
now i want to fetch records from a table with different conditions
i want to use a parameter as a column name in which i want to pass differnt field names and an other parametr to pass condition value.
here is the Sp by which i trying to fecth the data but could not....
pl help me
CREATE PROCEDURE TEMP1EMPINFO
--CREATE PROCEDURE TEMP1EMPINF
Select * from table where @tbl_col_name= @col_val
When using stored procedures with multiple statements, how do you tell your stored procedure to rollback any changes when the stored procedure did not successfully executed all statements?
It is said that the most complex structures built by mankind are software systems. This is not generally appreciated because most people cannot see them. Maybe that's a good thing because if we saw them as buildings, we'd deem many of them unsafe.