Viewing 15 posts - 121 through 135 (of 326 total)
The report project file will have an extension of .rptproj. You might try doing a wildcard search for the *.rptproj
July 24, 2008 at 6:10 am
From BOL:
If you want to run a package from a 64-bit SQL Server Agent job in 32-bit mode, select a job step type of Operating system, and enter a command...
July 18, 2008 at 9:46 am
It looks like the package is running in the 64 bit environment. Packages on a 64 bit server need to run in the WOW layer (32 bit) since SSIS is...
July 18, 2008 at 9:39 am
One simple thing I'd like to do is just print a list of the package variables, and their properties. Is there an easy way to do that?
I'm...
July 14, 2008 at 8:42 am
in Houston, only people with death wish are bikers
You're not kidding. I moved to Houston in '94 from CO. After getting here, I realized I would get killed if...
July 10, 2008 at 11:28 am
Let's hope none of your commutes are along the Cross Bronx Expressway in NYC - parts of it are congested over 90 hours a week! They should call it...
July 10, 2008 at 6:54 am
Actually this is exactly what I have done. I had a look at sp_send_dbmail but I couldn't see how you set the "from" value. This mechanism will be used by...
July 10, 2008 at 6:26 am
I think the problem is that there is no 64 bit Jet driver and packages that need Jet have to run in the 32 bit WOW layer. I vaguely remember...
June 18, 2008 at 6:45 am
We had MSFT give a class in Power Shell. All of .Net, WMI and more is accessible which means you can do everything in PS. Scripting in PS will probably...
June 11, 2008 at 7:20 am
Steve,
I won a copy also and since it is a licensed copy, I have been checking for and receiving regular updates. I now have the latest version and don't...
June 6, 2008 at 6:25 am
Sorry - I forgot that the less than and greater than symbols are for html tags so it come out right
ALTER TABLENAME
ALTER COLUMN ...
May 9, 2008 at 1:15 pm
sharma (5/8/2008)
I did
ALTER TABLE NVARCHARTBL
ALTER COLUMN NAME COLLATE default
The above query is correct?
Bcoz It shows error
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword...
May 9, 2008 at 7:14 am
jpeables - hmmm - I never noticed that. You would think MS wouldn't miss something like that. :ermm:
May 9, 2008 at 6:41 am
that is because you don't have SP2 installed. I asked earlier if this was a desktop client or a server.
May 9, 2008 at 6:25 am
to change the defaults for generating scripts, from the Menu bar select Tools, then options. The Options window should have scripting in the tree. Select it and change the defaults...
May 9, 2008 at 6:16 am
Viewing 15 posts - 121 through 135 (of 326 total)