Frank Kalis

Forum Replies Created

Viewing 15 posts - 3,331 through 3,345 (of 5,356 total)

RE: How can I connect to another database?

well, yes....too late
Frank
http://www.insidesql.de
http://www.familienzirkus.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 27, 2003 at 4:28 am

#483891
RE: How can I connect to another database?

hm, maybe
USE <some other databasename>
GO
?????
Frank
http://www.insidesql.de
http://www.familienzirkus.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 27, 2003 at 4:27 am

#483890
RE: Howto also copy/paste column name in Query Analyze

Also you can do this with a view in EM. After opening the view, mark the columns, Ctr+C and paste.
Frank
http://www.insidesql.de
http://www.familienzirkus.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 27, 2003 at 3:59 am

#483881
RE: New to SQL, have a version question

Not really, just a quick check, so I see you're at least some 6 hours behind. 10:00 in the morning. I usually sleep between 3:00 and 4:00 in the morning....
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 27, 2003 at 2:20 am

#483875
RE: New to SQL, have a version question

No problem!
Most members here follow all forums, I guess.
Btw, don't you think it's time to sleep over there
Frank
http://www.insidesql.de
http://www.familienzirkus.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 27, 2003 at 1:05 am

#483869
RE: New to SQL, have a version question

Sorry, too quick
GUI stands for Graphical User Interface, that is EM and QA
Frank
http://www.insidesql.de
http://www.familienzirkus.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 27, 2003 at 12:45 am

#483867
RE: New to SQL, have a version question

Double posts ?
See http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=18583
Frank
http://www.insidesql.de
http://www.familienzirkus.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 27, 2003 at 12:44 am

#483866
RE: QOD 27 Nov 03 - Edition Upgrades

What a great thread!
Just what I needed this morning
Frank
http://www.insidesql.de
http://www.familienzirkus.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 27, 2003 at 12:37 am

#483865
RE: Comments and Bugs on New Design

quote:
I just modified the homepage slightly to trim it down a bit and add some more functionality. Could you let me know...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 26, 2003 at 1:25 pm

#483817
RE: Comments and Bugs on New Design

Sorry, but I still see a 'privacy link' below. It links to http://counter.hitbox.com/a/hitboxfree.cgi. I've refreshed the cache several times but nothing changes.
Frank
http://www.insidesql.de
http://www.familienzirkus.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 26, 2003 at 1:19 pm

#483816
RE: Comments and Bugs on New Design

Well, Brian, you didn't kill the 'Privacy' link in the footer.
I don't know your legal requirements on this, but couldn't it be moved into the 'About Us' section?
Frank
http://www.insidesql.de
http://www.familienzirkus.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 26, 2003 at 12:45 pm

#483809
RE: Search in DTS packages

Have you already tried to search on http://www.sqldts.com ?
Frank
http://www.insidesql.de
http://www.familienzirkus.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 26, 2003 at 8:33 am

#483762
RE: DBA/Developer Growth

Well, err, yes Andy is right. Getting back on track.
Several threads here on this site, can't find any in my archive right now, but in addition to what already...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 26, 2003 at 8:14 am

#483755
RE: Recover from corrupt MDF or BAK

I once tried to bring a db back to life I intentionally corrupted. I didn't succeed. If you manage to edit it properly in a hex editor, please post again.
Frank
http://www.insidesql.de
http://www.familienzirkus.de
Edited...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 26, 2003 at 7:21 am

#483730
RE: relationships

Take a look at BOL for joins-SQL Server ->outer -> Using outer Joins.
I bet there is also something here in the script section
Frank
http://www.insidesql.de
http://www.familienzirkus.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

November 26, 2003 at 6:57 am

#483722

Viewing 15 posts - 3,331 through 3,345 (of 5,356 total)