Take a look at the Language setting at the server level, it determines the date format. US date format is month before day: today is 1/9/2005 or 2005-01-09. I notice in your question you are using day first.Also, is your import process using DTS? If so, check to see if any transform formatting the dates is defined […]
2005-01-09
I have used the following procedure to successfully test a disaster recovery scenario:1. Back up the ReportServer database in SQL as you would normally back up any SQL db. 2. Use the rskeymgmt utility to back up the symmetric encryption keys (used to provide encryption/decryption of sensitive data within the ReportServer database). For example, the […]
2004-12-30
I am trying to export data from one sql server instance to another on another domain.however trying to connect to the remote instance never works due to 'login failed' error.i have access to the remote domain and can verify that the login is correct.what is the problem?
2004-12-24
Hi, I need some help.It's possible to create or restore a databse using the .mdf file and log file?.I'm trying to create the database in my local server but I don't have a backup file to restore from it, the only files that I have is mdf file and log file. Thanks a lot for your helpGreetingsER_SQL
2004-12-23
We have a linked server to a DB2/As400 using an ODBC and can pull data fine. Never tried a push, but it probably depends on the driver. We also us an OLE DB driver called HiT to push data to an AS400, but it's also supposed to be able to push to DB2 as well. Not […]
2004-12-23
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-12-03
I know it almost sounds like blasphemy in this place, but have you considered the use of an open source system?
2004-12-03
quote: There are other implications that were not mentioned here like: DTS DOESN'T WORK on fiber mode and that is huge for some enviroments. It is the case that DTC doesn't work with fiber mode:http://support.microsoft.com/default.aspx?scid=kb;en-us;303287
2004-11-22
hi all;first; thanks all for this high quality support, i will try to squeeze my time and help people around here as an appreciation for your support.back to the issue; i decided to go with the solution of adding the extra field; this solved the issue and resulted in a much faster and cleaner solution. […]
2004-11-15
What you have, from the description, is what is called a slowly changing dimension. In other words, the information can change, but not all that often.You have to make a decision on the design. For example, if the patient is a woman and she gets married. Do you want her old name as well as […]
2004-10-27
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers