Viewing 15 posts - 496 through 510 (of 625 total)
Thanks Phil,
Option 1 seems possible. It would be a little more complicated than it seems since i was hoping to also dynamically create worksheets. I may go done this road...
May 24, 2011 at 2:35 pm
I hoping to generate scripts which I could run on a different server so I'll need sp_help_revlogin. I may look at SSIS or maybe return back to my adventures with...
May 20, 2011 at 4:24 pm
Can anyone provide specifics on using BCP through SQL Agent?
I have a 'Operating system (CmdExec)' step set up with the following command.
bcp master.dbo.sp_help_revlogin out c:\test.txt -n -SMYSERVER\MYINSTANCE -T
I am getting...
May 18, 2011 at 5:15 pm
I ended up modifying the procedure uspCientfavoriteLists to accept one parameters @client instead of 2, @client and @ListType.
I am then filtering the returned results at the tablix level. ListType...
May 18, 2011 at 2:10 pm
Perry Whittle (5/18/2011)
I prefer BCP for my login exports
Doesn't BCP require xp_cmdshell to call it?
May 18, 2011 at 10:20 am
I'm running into this issue when I try to edit a job with a powershell step.
I thinks this is unrelated to the powershell script.
This works from the ps...
May 18, 2011 at 9:35 am
Hmmm yeah thats a good idea. I could include the embedded html and the file in every email. I could also check the length of the string and if it...
May 12, 2011 at 3:25 pm
Perhaps this...
INSERT INTO dbo.Purchasing(PartNumber, IsHardware, KitAlways, ChinaPN, KitChina, InstallTime, LaborClass, UnitCost)
SELECT
RIGHT('000000' + convert(varchar(6), PartNo), 6),
0,
0,
RIGHT('000000' + convert(varchar(6), PartNo), 6),
0,
10,
1,
null
FROM
dbo.Purchased
WHERE RIGHT('000000' + convert(varchar(6), PartNo), 6) NOT IN
(
SELECT PartNumber FROM dbo.Purchasing
)
May 12, 2011 at 10:40 am
Oh thanks, that's simple, somehow I never used WHILE before.
This syntax is not allowed with xp_smtp_sendmail.
@message = @string + @string2
I'll seems like I will need to migrate...
May 12, 2011 at 10:19 am
Yes if you could help me generate the string that would be appreciated.
I want to try something like this so I can determine if xp_smtp_sendmail will accept something greater than...
May 12, 2011 at 9:29 am
Also. Can anyone help me purposefully build a string greater than 8000 characters?
I imagine I need the LEN function and some type of loop...
May 12, 2011 at 9:19 am
>>Can the references be set up during the import as in a package or is it done after getting the data into the database?
Either way is possible. You can have...
May 10, 2011 at 1:32 pm
Along with virtual servers come virtual ethernet adapters, virtual switches, virtual ports, etc. If enabled there can be an entirely separate virtual networking structure. Your virtual host may be inaccessible...
May 10, 2011 at 9:39 am
This seems to indicate that when using the migration wizard you can go directly to the msdb database or dtsx file.
http://msdn.microsoft.com/en-us/library/ms143496.aspx
Since you can't see the files I...
May 10, 2011 at 9:25 am
Viewing 15 posts - 496 through 510 (of 625 total)