Viewing 15 posts - 511 through 525 (of 629 total)
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
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
Is there an existing application or reporting tool that already is writing or retrieving data against the data?
If so you can run the SQL Server Profiler tool to see what...
May 4, 2011 at 9:23 am
Thank you both. This has been educational and I have been able to unequivocally demonstrate to my very expensive and supposedly enterprise-level vendor that their product is just not very...
May 2, 2011 at 1:10 pm
Thank you so much. A few more questions if I may.
Am I correct in thinking that this character may not show up, that is be visible, in a normal text...
May 2, 2011 at 11:59 am
I get this
subloc(No column name)
148
246
357
457
513
May 2, 2011 at 11:45 am
SELECT'*'+IssuerValue+'*' returns '*0.99 *' as an example. It appears to be a space. If I add IssuerValue LIKE '% ' to my WHERE statement nothing is returned.
ISNUMERIC(IssuerValue) = 0 returns...
May 2, 2011 at 11:31 am
Phil Parkin (5/2/2011)
the problem is not visible in the csv file.
Are you sure? How did you check? What do you want to do with the bad data?
I checked in a...
May 2, 2011 at 11:21 am
Here is a kludge possible solution if you really want it.
Create a a master generic table with enough columns to accommodate your widest result set. They'll probably need to be...
April 29, 2011 at 1:31 pm
Oh I'm sorry you answered that question. Are the three sections side by side or underneath each other?
April 29, 2011 at 9:38 am
Viewing 15 posts - 511 through 525 (of 629 total)