Viewing 15 posts - 526 through 540 (of 636 total)
I have noticed if something goes wrong inside the stored proc while running, SSRS will display the
ugly error information. Well, if that can happen i am sure there is...
January 18, 2012 at 8:51 am
DO NOT REPLY TO THIS POST ANY MORE.. I am not interested in ULTREDIT.
I changed my mind.
This is the best SQL FORMATTING TOOL. TRY THIS ONLINE AND YOU WILL BE...
January 13, 2012 at 2:26 pm
Team:
1. I have a SSIS job that backs up the CATALOG table daily ( at 10 PM ).
What I like to do is before I update the backup table...
January 12, 2012 at 9:28 am
Thanks
That worked!
Great job.I guess why didn't I bother to look whether we had a users table ? Shame of me.
Thanks again
January 12, 2012 at 9:18 am
Both of you are heading in the wrong track. The owner of this topic wants to know whether a file delivered via SSRS can have a dynamic file name ?
The...
January 10, 2012 at 11:26 am
May I ask what stands for DMO and SMO
( In this new age we are bombarded with two many mnemonics )
January 10, 2012 at 7:53 am
Yes Sir!
This will do
I may have to modify the script to take care of some quirks but for now, This is the best!
The script only covers tables in the dbo...
January 9, 2012 at 8:08 am
I am definitely familiar with SSIS.
Give me a clue here.
I guess I am not explaining myself clearly. What I need is the same script that can be generated
via...
January 9, 2012 at 7:35 am
Agreed!
However, this gives us all the tables. Not a problem.
My next question is, can this task be automated via a SSIS ?
What I mean is can I have a ...
January 9, 2012 at 6:56 am
Gentlemen, good job!
My next question, is how do I "run in 32 bit mode?"
Where can I find this setting ? Is this something I have to set in the package...
January 6, 2012 at 11:53 am
sp_help 'Table Name' throws out many layers of information. This would be ideal for just checking one table at a time just to get information.
What we need is a way...
January 5, 2012 at 7:42 am
So far managed to come up with this.
I think I this may be sufficient for now. It may not give the script. But has the info I need.
SELECT d.name...
January 4, 2012 at 2:53 pm
or can some one help me here with this antiquated query.
This works fine. Just that it does not use sys.objects or sys.columns.
what i need is to be able to join...
January 4, 2012 at 2:20 pm
One way to do it is to install the following stored proc written by a GURU
http://www.techrepublic.com/blog/datacenter/script-table-definitions-using-tsql/431
January 4, 2012 at 2:18 pm
I know of I play around I will get it.
But then what I wanted is for a "GURU" to just throw the SQL statement for me ( Ha Ha )
January 4, 2012 at 2:05 pm
Viewing 15 posts - 526 through 540 (of 636 total)