Viewing 15 posts - 2,356 through 2,370 (of 3,221 total)
Grant Fritchey
Anyway, that's the one thing I'd like to see. More direct support for the local users groups
Grant used Live Meeting to make a presentation to the Columbus SQL Server...
October 22, 2009 at 10:12 am
Oprn SSMS right click on the database name, select Properties, in the next window select Options, expand if necessary the heading automatic it should show you there.
October 22, 2009 at 8:15 am
Ran across this blog post by Jack Corbet titled "Maintaining Security and Performance using Stored Procedures" at:
Which details a method of using the EXECUTE AS feature, and this...
October 21, 2009 at 1:52 pm
Use BOL (Books On Line -SQL Help File)
Start with gaining an understanding of database and log back ups and their effect on logfile size.
And then look at SQL...
October 21, 2009 at 12:49 pm
Phil Parkin
Thanks for doing that additional testing.
As you said in a previous post on this forum. The OP may have another problem.
Again thanks for doing that additional testing.
October 21, 2009 at 12:23 pm
that is a good start,
Are you commenting on the MSSQL Tips posting?
October 21, 2009 at 12:18 pm
This will not give you a simple list, but rather everything you wanted to know about users and their permissions. It produces a HTML document. The actual T-SQL...
October 21, 2009 at 12:10 pm
Just an idea, if you have not already thought of it.
How about creating a copy of the database on a non production server,
then you can give them whatever access they...
October 21, 2009 at 11:46 am
Phil Parkin
You are wrong in thinking that SSIS cannot import values from Excel which are the result of calculations. I just tried this and it works fine.
Phil did the...
October 21, 2009 at 9:55 am
1. Check those cells to see if they contain a formula
If they do then
2. Check Excel help for "Replace a formula with its result"
Unfortunately the only instructions...
October 21, 2009 at 9:21 am
Anzer Muhammad
An interesting and challenging question.
However it is more likely to be answered if you follow the examples of how to post a question (refer to the link...
October 21, 2009 at 6:56 am
WayneS
You are between a rock and a hard place. My sympathies are with you.
October 20, 2009 at 12:09 pm
WayneS
Just had a "developer" send me some code.
Wayne I submit that your problem is NOT with the developer but with either the hiring/current Manager who think that the individual is...
October 20, 2009 at 8:40 am
jim.lawrence
Not had a chance to see a fresh install of SQL Server 2008
A fresh install of the Developer Edition - which is supposed to be identical to the Enerprise...
October 20, 2009 at 6:47 am
There are quirks with Excel, particularly that the Excel data source takes the data type of the columns from the first eight rows
When using OPENROWSET to read the EXCEL...
October 19, 2009 at 8:30 am
Viewing 15 posts - 2,356 through 2,370 (of 3,221 total)