Forum Replies Created
Viewing 15 posts - 2,926 through 2,940 (of 5,356 total)
-
RE: Change user defined SP to system SP!!
Who knows?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Documentation of system SPs, UDFs, Tables and columns
Forgot to ask:
Are you on SQL Server 2000?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Documentation of system SPs, UDFs, Tables and columns
Send me a private message with you email address, so I can send you a html help file which describes the system tables.
The table map is a poster that...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Documentation of system SPs, UDFs, Tables and columns
Hey biker,
your avatar is also kinda cool! Although I prefer a Fireblade
Now, for the pseudo topic relation:
I think Andy Warren mentioned some time...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Storing Media Files
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp should cover most of your questions
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Change user defined SP to system SP!!
IIRC, when you edit and save it will become a user procedure again
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Local SQL database on client machine?
I would definitely redesign your application.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Local SQL database on client machine?
Would that make sense?
I can understand when someone uses this approach (local dbs' that get uploaded during off-peak hours) when you were using Access, but with SQL Server I would...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: XP_CMDSHELL Results Question
From BOL
When xp_cmdshell is invoked by a user who is a member of the sysadmin fixed server role, xp_cmdshell will be executed under the security context in which the SQL...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Removing the ---- line from the result set
Any reasons why you're doing this at the server and not at the client?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Replacing TSEQUAL function
TSEQUAL is not totally undocumented.
Although BOL lacks an explanation of use to use this function, you can find it in the list of reserved keywords for SQL Server.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Removing the ---- line from the result set
Not sure if I understand you.
Can you post your code?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: To get system information from sqlserver
Hey, if it fails we could blame David
I had actually only the reference to the original thread in the old forum, and was...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Change user defined SP to system SP!!
Yes, take a look at the undocumented sp_MS_marksystemobject
in your master db.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: To get system information from sqlserver
I was not sure if it works, but here is the complete thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=18764
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 2,926 through 2,940 (of 5,356 total)