Viewing 15 posts - 4,726 through 4,740 (of 13,465 total)
duplicate post.
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Recent Posts" link shows us everything.
continue the thread here:
http://www.sqlservercentral.com/Forums/Topic1360942-391-1.aspx
September 18, 2012 at 12:51 pm
just to pile on the bad news; Excel 2010 is limited to a max of 16384 columns.
so you need a few more(10+?) worksheets or so.
September 18, 2012 at 12:48 pm
I've tripped over this with some of our web services.
it has to do with a default limit in the expected string size; i guess MS expected most services return tiny...
September 18, 2012 at 12:25 pm
is this more of a syntax question, or the wrong applicaiton, i wonder.
i use the command line version of 7zip, which is 7za.exe;
are you using the GUI version? I'm not...
September 18, 2012 at 9:35 am
Brian Brown-204626 (9/18/2012)
The SQL Server login already exists, but I need to grant access to a database from a T-SQL command, rather than use Management Studio.
granting access to a database...
September 18, 2012 at 8:24 am
i just tripped over this exact lack of planning by the database architect when switching from one insurance agency to another. From Geico to Progressive: I saved 30% or more...
September 18, 2012 at 7:52 am
two built in functions should get you what you are after:
SELECT YEAR(getdate())
September 18, 2012 at 6:56 am
in SQl 2000, it was certainly possible to leave a setting ON so that subsequent objects were created as system objects.
once an object is marked as a system object, you...
September 18, 2012 at 6:28 am
i think it's because of two things:
when you create a SQL user, that implicitly grants the CONNECT permissions; logins from the domain already exist, so it makes sense...
September 17, 2012 at 2:32 pm
There is no DML Event Notifications;
there used to be a mistake in the documentation that seems to imply it, but if you look at the actual events available, they are...
September 17, 2012 at 9:18 am
that's because the old comma syntax didn't support left/right joins without that old =* or *= syntax (or the oracle the old styles pretty muich only inner joins without them
=columnname(+)...
September 14, 2012 at 6:55 am
yes it's true; there are two ways to cross join tables.
SQL server supports the old syntax of FROM TABLE1,TABLE2 as well as the more modern, explicit FROM TABLE1 CROSS JOIN...
September 14, 2012 at 5:26 am
here's the data as a readyly consumable CTE;
if i knew what the process was doing, we could add a lot more to this:
With MyTableExample ([Doc Number],[Document Date],[Rec Date],[Book],[Vol],[Page],[Doc Type],[# of...
September 13, 2012 at 2:53 pm
oh yeah, i'm very familiar with the server side trace, but that only can capture the command text that was executed, for example.It cannot catch old versus new values, which...
September 13, 2012 at 2:49 pm
CptCrusty1 (9/13/2012)
Pray tell... more feedback on what you're refering to...
BTW... RBAR.......
September 13, 2012 at 2:46 pm
Viewing 15 posts - 4,726 through 4,740 (of 13,465 total)