Forum Replies Created
Viewing 15 posts - 3,811 through 3,825 (of 5,356 total)
-
RE: To delete temp tables or not to?
Although BOL states that
quote:
If a temporary table is not dropped when a user disconnects, SQL Server automatically drops the temporary table--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Do Entry-Level Databasing Jobs Exist ?
quote:
Your best bet (in my opinion) for success at such a tactic is in a very small company, or a very large...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Locked out - please help
What about putting BUILTIN\Administrators back in, assign proper permissions and take the time to think about what went wrong?
Which OS version and service pack!!! are you on?
Just curious, but under...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Sql Server2000 Service Packs
quote:
I just installed SQL Server2000 Developer Edition ("Release A" on the CD). In the box is a CD for SP3a (do...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: URGENT Manual statistics creation vs Autocreating
quote:
My question is -1. Will it be more efficient to create/update statistics manually ?
2. If Ans of pt. 1 is Yes...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Permissions to see last TSQL command
Btw, I've been added back to sysadmins.
It pays when you keep the network admins who control the server busy with something they can't answer
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Permissions to see last TSQL command
quote:
I tried, It doesn't have to permissions to see other people's processes. It can be use to kill processes.--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: Java stored proc support in sql server 2000
quote:
Is there any kind of direct or indirect support of java stored procedure in sql server 2000 sp3a.Any resource/link etc are appreciated.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: Is XML the Answer?
quote:
The Information Technology arena has no room for extremists. Use the right paradigm/methodology/tool for the job.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: Adding a new column to a table -Advanced-
Hi mirroras,
quote:
hello AllI have the table :[my_photogallery]
with the fields below:
[my_photogallery_id] [int] IDENTITY (1, 1) NOT NULL ,
[my_photogallery_cat_id] [int] NULL ,
[my_photogallery_title] [nvarchar]...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: Permissions to see last TSQL command
hm...any experience with 'processadmin'?
that little that is in BOL sounds interesting
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: Permissions to see last TSQL command
Hi Allen,
quote:
You actually call dbcc inputbuffer command to see the last TSQL command.DBCC INPUTBUFFER permissions default to members of the sysadmin fixed...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: QOD 7 Oct - Multiple Ports
quote:
Hi Frank. The job's keeping me out of trouble. A touch boring at the moment, but there's some signs of new...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: QOD 7 Oct - Multiple Ports
quote:
I try to be a good environmental boy and recycle whatever can be recycled. But QODs?Come on everyone, let's try to...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: Is XML the Answer?
quote:
quote:
Hierarchal data is a pain to manage and administer but it's main advantage is...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 3,811 through 3,825 (of 5,356 total)