Viewing 15 posts - 15,856 through 15,870 (of 39,824 total)
By default, you have no permissions on an object, say a table called "Sales"
If I use GRANT, I add permissions for you to view sales.
If I then use REVOKE, I...
June 9, 2011 at 1:59 pm
Someone sent me this: http://scrubs.codeplex.com/
HTH
June 9, 2011 at 1:22 pm
I'd look at virtual file stats for the tempdb data file.
Quite a few posts here as well: http://blogs.msdn.com/b/sqlserverstorageengine/archive/tags/tempdb/
Ultimately it comes down to measuring how much the...
June 9, 2011 at 1:21 pm
GilaMonster (6/9/2011)
Steve Jones - SSC Editor (6/9/2011)
June 9, 2011 at 1:05 pm
I am not an expert on those tools, but from what I understand, those tools are more built to manage the server itself. They look at performance and activity, but...
June 9, 2011 at 1:04 pm
Just an FYI, those of you that posted in the "real world financial problem", I whacked the thread. No replies or discussion seemed to be of use to the site...
June 9, 2011 at 12:56 pm
Short way: grant new permissions first, then revoke old ones.
As mentioned above, you need to determine their permissions. You can use this to help: http://msdn.microsoft.com/en-us/library/ms176097.aspx
What you want to do...
June 9, 2011 at 12:54 pm
Stefan Krzywicki (6/9/2011)
The biggest surprise for me was when I had to have a headlight replaced. I went in to the dealership expecting the typical $20 (On other cars I...
June 9, 2011 at 12:42 pm
I don't know of anything that will tell you what is being used from an automated fashion. I suspect that you'd need something that combs through SSRS logs and tries...
June 9, 2011 at 12:38 pm
Just ran this:
C:\Users\Steve>bcp "select * from db1.dbo.mytable" queryout out.txt -C -T -t "|" -S sevenfalls
I didn't see a server name in yours.
June 9, 2011 at 12:30 pm
Haven't tested them together, but both have worked for me. I have been hesitant to use them without stopping SQL Server. Even then, make sure I have 2 backups, just...
June 9, 2011 at 12:26 pm
Not to make it more complicated, but where are backup files going? I'd make sure you have space somewhere separate from the data files.
Do you use tempdb a lot? If...
June 9, 2011 at 12:22 pm
The transfer task, if it's the same as 2005, just automates the object creation and then the transfer of data from one place to another.
It works, but you could potentially...
June 9, 2011 at 12:18 pm
Be careful of using LEN, as noted by Philpacha.
Datalength is much better: http://msdn.microsoft.com/en-us/library/ms173486.aspx
June 9, 2011 at 12:15 pm
Note that the default trace is limited in size, so it might not be there.
This can be hard to track down if a lot of activity has happened on the...
June 9, 2011 at 12:12 pm
Viewing 15 posts - 15,856 through 15,870 (of 39,824 total)