Viewing 15 posts - 511 through 525 (of 638 total)
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 command line
invoke-sqlcmd...
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 assume you...
May 10, 2011 at 9:25 am
If you search this site for 'Search DTS for string' you'll see several leads.
Is this a a 2000 server or a 2005 server with legacy DTS packages?
May 9, 2011 at 3:24 pm
Also keep in mind that you can export the packages to xml files and then do a search/replace using a text editor and then re-import. Perhaps this could help depending...
May 9, 2011 at 12:26 pm
>>Here's my situation: I have to refresh table data nightly; however I need to leave everything else (procedures, views, stored procedures) intact.
Maybe you can script out all the views and...
May 5, 2011 at 12:22 pm
Viewing 15 posts - 511 through 525 (of 638 total)