Viewing 15 posts - 6,781 through 6,795 (of 7,168 total)
Here is a free tool that may help get you started on the scripting part of your task:
http://www.idera.com/Products/Free-Tools/SQL-permissions/%5B/url%5D
March 28, 2011 at 4:12 pm
emilybrank (3/28/2011)
March 28, 2011 at 3:27 pm
For your first question, you do not need to qualify the column you are updating. Try this:
UPDATE a
SET PO_ITEM_CATEGORY = b.[segment3]
FROM dbo.trialInvoice...
March 28, 2011 at 3:25 pm
I like the Transcender products. I have used them for years going back to the VB6/SQL7 days.
March 28, 2011 at 3:21 pm
master.dbo (3/28/2011)
that fixed it!you're awesome
Cool, I am happy I could help 😀
March 28, 2011 at 1:49 pm
Try connecting remotely after starting the SQL Server Browser service.
edit: I noticed it was not Disabled, just set to a startup type of Manual...so all that is needed it to...
March 28, 2011 at 1:39 pm
Some random thoughts...
How are you trying to connect from your workstation? TCP/IP?
- Check the "SQL Server Configuration Manager" to see which protocols are enabled on the DB server.
Is SSRS...
March 28, 2011 at 1:12 pm
My opinion...you may be reading too much into the word "refresh" in the question. I have found many of the exam questions to be delightfully ambiguous. Based on the set...
March 28, 2011 at 1:04 pm
As Dan mentioned master.sys.xp_readerrorlog can be used to read the contents of an error log into a table. The example Dan provided reads the most current log (log 0) but...
March 28, 2011 at 12:53 pm
To my knowledge SSIS does not implicitly add a row number to your data set that you can reference. I think you will first need to manually add a row...
March 28, 2011 at 12:30 pm
Approaching it with a CTE may make your code a bit more readable. Your original query plus an ORDER BY is first followed by mine which uses a CTE. It...
March 28, 2011 at 12:24 pm
You can see them all here for SQL Server 2008 R2 RTM:
http://support.microsoft.com/kb/981356
Whenever a new CU is released the KB article is updated. MS has a KB article for...
March 28, 2011 at 12:05 pm
As Jeff said, if your consolidated EXPENSES table will reside in the same instance as the 72 dept tables then you do not need SSIS.
If you are looking into SSIS...
March 28, 2011 at 11:49 am
I asked for the source table (expecting it to be different) because I am having trouble confirming the data in the file came from a table with the definition you...
March 28, 2011 at 11:27 am
Can you please provide the definition of the source table as well?
March 28, 2011 at 10:38 am
Viewing 15 posts - 6,781 through 6,795 (of 7,168 total)