Viewing 15 posts - 1,111 through 1,125 (of 1,226 total)
Based on your data flow, did you encrypt the copy of ssn columns and then tried throwing that encryption value into an Excel cell? This may be causing your error...
March 19, 2013 at 11:07 am
Stop SQL Server and restart it in single user mode. Then from management studio right click the master database and and use this menu to restore form your backup device....
March 18, 2013 at 11:26 am
You may need to coordinate with your IT group. Sometimes the Exchange server ( I assume it is Exchange) may have rules that do not accept messages from unknown domains...
March 18, 2013 at 10:59 am
The lookup function is not available in SSRS 2005. Wondering if the OP still has this issue.
March 18, 2013 at 10:46 am
I would add the group id that the employee is in to the dim user table as well. This will allow group counts.
March 18, 2013 at 10:40 am
The user wants to compare this year to last. You can create two temp tables representing counts this year and last, grouped on date (no time portion) and status....
February 28, 2013 at 3:26 pm
Hi. Is there been any updates on this matter?
February 27, 2013 at 10:28 am
I refer to the 1:1 between an entity and a phone number. The OP refers to a store. If I wanted to reach a certain number of the store that...
February 17, 2013 at 12:22 pm
So in your model, if I got a new cell phone and number , you would need to create a new entry for me. Do you know for a fact...
February 15, 2013 at 3:10 pm
I think we need to know what the two date columns represent, so that we do not guess. It looks to me the update column is like a record time...
February 15, 2013 at 2:59 pm
Could it be there was a momentary loss of connectivity to the domain controller and the credentials passed could not be verified? I don't recall if I've encountered this particular...
February 14, 2013 at 3:16 pm
Also we would like to know if you would be running the report once a day, week , month? It seems to me that at any point you execute...
February 11, 2013 at 3:21 pm
Depending on your business requirements you may instead want to apply the above logic using a time stamp column, which you would need to add.
February 11, 2013 at 3:14 pm
we do not have access to msdb folder
Do you mean the folder in SSMS when you connect to Integration Services on your server, or some windows folder ?
February 11, 2013 at 2:52 pm
Viewing 15 posts - 1,111 through 1,125 (of 1,226 total)