Viewing 15 posts - 15,811 through 15,825 (of 39,970 total)
Note that this is a manual process. If you add logins to the primary, it should be with a script, and you should amend the script to also add the...
June 24, 2011 at 5:12 pm
Never seen anything like this. Unless you perhaps had implicit transactions off. Perhaps one started and didn't commit?
The SELECT should return the rows, however, if it's the same connection.
I would...
June 24, 2011 at 5:05 pm
That is strange. I might set up a trace that logs activity to see what is happening here.
June 24, 2011 at 5:01 pm
There is no IF() function in T-SQL. You're mixing something from another language in there.
SELECT
room_type,rate_start_date,rate_end_date,rate
, DATEDIFF( case when rate_end_date > '2011-04-16'
...
June 24, 2011 at 4:58 pm
I like the idea of using a trace over time, but if you find databases that aren't in the default trace, I'd close them and set them offline. That way...
June 24, 2011 at 4:56 pm
Note that you cannot be sure this will work. A DBA in control of the physical machine can always log in and remove logs, trace files, disable traces, etc. You...
June 24, 2011 at 3:20 pm
No idea on IPStor.
However both database mirroring and log shipping do the same thing: ship transactions from the log to the other server. Log shipping works with log backups, so...
June 24, 2011 at 3:16 pm
Kirin, Sapporo, Asahi, I'll take any of them with a hot bottle of sake.
June 24, 2011 at 2:56 pm
Thanks for the update. That's good to know. Should have thought of looking for strange characters in there. My apologies.
June 24, 2011 at 2:55 pm
I never restart instances unless there are patches and I need to. The log has nothing to do with restarts, as mentioned.
Read Gail's link and manage your transaction log.
June 24, 2011 at 10:17 am
You are correct. You gain nothing preserving it on SQL Server. Now depending on server memory, load, and the data set, it's likely in memory on SQL Server so it's...
June 23, 2011 at 5:38 pm
wait, wait, wait.
I think you're confused about what is happening. When you start (before page 1), you have:
SQL Server: dataset needed for user 1 + other data
Web server: no data
Client:...
June 23, 2011 at 3:53 pm
Did you grant "log on as a service" to the account?
I might set up a new domain account (base user, no rights), then use Config Manager to assign this to...
June 23, 2011 at 3:09 pm
Saw three movies in the last two weeks, a record for me since I think I've only seen 3 or 4 the whole year before that.
- Hangover 2, ehhh, OK
-...
June 23, 2011 at 2:53 pm
Can you let us know what it is? just in case someone else hits this thread.
June 23, 2011 at 2:39 pm
Viewing 15 posts - 15,811 through 15,825 (of 39,970 total)