Viewing 15 posts - 841 through 855 (of 1,409 total)
The master database contains all information about the instance settings, logins, userdatabase definitions, etc. Any changes made after the available backup time (like a password change, adding/removing a database) have...
August 15, 2013 at 4:27 am
TC-416047 (8/15/2013)
First thanks for the response! Very much appreciated.I only have the mdf and ldf files for the master db.
how should/can I restore them?
If you have a backup available, it...
August 15, 2013 at 4:16 am
TC-416047 (8/15/2013)
Since I already attached the production database aren't the UIDs already changed?I'm uncertain about the order of things to do.
The UID of the user is stored in the...
August 15, 2013 at 4:06 am
If possible, restore the [master] database from the last good backup (or more and very(!) risky: use the mdf/ldf files). When you have restored the master database, all logins are...
August 15, 2013 at 3:35 am
khurmi.navpreet (8/15/2013)- Check if the login is connected to the user in the database: use {db_name};exec sp_change_users_login 'Report' - Executed this command but it gave me only 2 usernames with...
August 15, 2013 at 2:43 am
That's a nice problem you have on your hands.
My first guess would be to create an additional (calculated) column and put in the value without all special characters (F120SB). Also...
August 15, 2013 at 2:10 am
First, take a step back and clearly think about your requirements and purpose.
- Like Jeff mentioned: do you really need a duplicate of all the data in the four tables,...
August 15, 2013 at 1:53 am
You don't give us much information. Can you specify your needs and describe the purpose?
Perhaps you can create a SQL Agent job that executes your command at the specified time(s)?
August 15, 2013 at 12:23 am
Please make it clear if it involves a MS Access database (because you posted this in the MS Access forum) or a SQL Server database (like you mention in the...
August 14, 2013 at 11:44 pm
To meet your demands you first have to define a table with an identity column. Then you need to read the file line-by-line and add these as seperate records to...
August 14, 2013 at 11:49 am
Why do you need to keep a sort order during the insert? The sort order is only required during a display (SELECT) of the results and can be accomplished (and...
August 14, 2013 at 7:39 am
I guess this wouldn't be the most elegant/easy/fastest solution, so other options will still be welcome.
You can import the file into a (temporary) table of a single NVARCHAR(....) column. After...
August 14, 2013 at 5:58 am
Microsoft has made a support article about this. Take a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;240867. It applies to SQL2000 but I guess it won't differ much for SQL2005.
August 14, 2013 at 5:08 am
It is almost impossible to get information about actions being taken in the past, if you don't have some kind of auditing/logging/tracing active. If it is important to know who...
August 14, 2013 at 4:48 am
Maybe it's removed to prevent "cheating". If you have read the answer it has no point in answering the question 😎
If you want the explanation, just try to answer the...
July 24, 2013 at 7:00 am
Viewing 15 posts - 841 through 855 (of 1,409 total)