Viewing 15 posts - 15,196 through 15,210 (of 39,970 total)
Using scripts for changes is the best solution, hopefully scripts that someone else has looked at and include some error handling or checks for incorrect (or too many) changes to...
September 26, 2011 at 11:28 am
SQL Server queries the Windows host date/time. This is used for all it's internal time marking of events (trace, events, etc.) and it is returned by getdate() or SYSDATETIME()
September 26, 2011 at 11:25 am
What do you mean by modeling the extract and staging?
Staging is setting up tables that receive the data intermediately. You may or may not do this, but these tables usually...
September 26, 2011 at 7:25 am
Your sentence doesn't make sense. The SQL Server service account is the same Windows admin account that is running SQL?
It is possible to lock files/folders from Administrator. Just because...
September 26, 2011 at 7:09 am
Search auditing on this site. We have numerous articles on the subject.
September 24, 2011 at 6:35 pm
The structure of the new system is set, correct? If you have purchased it, then you have a schema and objects.
Migrating the data from an old system or a warehouse...
September 24, 2011 at 6:34 pm
If you have this table:
create table mytable
( mychar nvarchar(4000)
, mytext ntext
)
then I can do this:
UPDATE dbo.mytable
SET mytext = mychar + CAST( mytext AS NVARCHAR(MAX))
That will concatenate the values...
September 24, 2011 at 6:32 pm
Typically you create a forwarder to move mail from one system to another. Or a rule.
Maybe this will help: https://mail.google.com/support/bin/answer.py?answer=10957
September 24, 2011 at 6:25 pm
not a master reference, but here's some history: http://en.wikipedia.org/wiki/Password_Safe
I want to say that I read about it in one of his books. It was an initiative to try and get...
September 24, 2011 at 6:23 pm
I haven't, but I also know a few security researchers find it secure. I don't have the time, nor the knowledge, to understand how to write a secure, strong encryption...
September 23, 2011 at 5:29 pm
Is there a chance there's a quota? Can you log in as the service account and test that way? It might help track things down.
Sorry for the delay in responding.
September 23, 2011 at 4:56 pm
Then it's not security. Is this valid on the SQL Server windows host?
C:\Program Files (x86)\WinRAR\unrar
September 23, 2011 at 12:48 pm
Did a file get created in the folder?
September 23, 2011 at 12:39 pm
GSquared (9/23/2011)
Grant Fritchey (9/23/2011)
The more I travel, the more...
September 23, 2011 at 12:38 pm
Viewing 15 posts - 15,196 through 15,210 (of 39,970 total)