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 -
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... -
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...
-
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... -
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...
-
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
-
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.October 8, 2003 at 2:22 am
-
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. -
RE: Is XML the Answer?
quote:
The Information Technology arena has no room for extremists. Use the right paradigm/methodology/tool for the job. -
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]...
-
RE: Permissions to see last TSQL command
hm...any experience with 'processadmin'?
that little that is in BOL sounds interesting
Frank
-
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...
-
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... -
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...
-
RE: Is XML the Answer?
quote:
quote:
Hierarchal data is a pain to manage and administer but it's main advantage is...
Viewing 15 posts - 3,811 through 3,825 (of 5,356 total)