Forum Replies Created

Viewing 15 posts - 10,996 through 11,010 (of 18,923 total)

  • RE: User access

    Can you setup a backup of the db with only those 2 tables and grant him create view there?

    November 21, 2006 at 1:15 pm

    #673312

  • RE: DBCC DBReindex

    Does that include log activity and size required in tempdb???

     

    I just checked my log backups after a reindex and they are at least the size of the DB.

    November 21, 2006 at 12:56 pm

    #673304

  • RE: weird character in the data

    Does this help?

    DECLARE @s AS VARCHAR(10)

    SET @s = ' 123456 ' + CHAR(13) + CHAR(10)

    PRINT @s + 'line fed'

    SET @s = REPLACE

    November 21, 2006 at 12:46 pm

    #673300

  • RE: How to know who is executing a stored proc

    IF EXISTS(SELECT * FROM dbo.SysObjects WHERE Name = '' AND XType = 'U' AND USER_NAME(uid) = 'dbo')

           DROP TABLE dbo.ProcActivity

    GO

    CREATE TABLE dbo.ProcActivity 

    (

             DateActivity DATETIME NOT NULL 

    November 21, 2006 at 12:41 pm

    #673297

  • RE: Modify the Auto Number

    Yes and no... what do you need exactly?

    November 21, 2006 at 12:20 pm

    #673290

  • RE: User access

    Won't that grant access to edit other views too??

    November 21, 2006 at 12:18 pm

    #673289

  • RE: ALTER VIEW-will index be recreated or reindexed?

    No idea... and no time to create a test for it.  I'm anxious to see how this one turns out however .

    November 21, 2006 at 11:58 am

    #673285

  • RE: ALTER VIEW-will index be recreated or reindexed?

    Something went wrong. Can you repost the message?

    November 21, 2006 at 11:53 am

    #673281

  • RE: Managment

    All usefull links listed here :

     

    http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=SQLH2&DisplayLang=en

    November 21, 2006 at 9:47 am

    #673253

  • RE: Managment

    2040 or 2005 ?

     

    Also anyway you can afford to have one or 2 critical servers fail for 1 or 2 hours so they really...

    November 21, 2006 at 8:26 am

    #673235

  • RE: Alter Index rebuild

    That is out of my competence area.  I'll leave this question opened to all other DBAs with relevent experience and information.

     

    Good luck with this problem!

    November 21, 2006 at 8:24 am

    #673232

  • RE: Clearing up objects from cache selectively

    I see.  Here I have the luxury of being able to run a full backup / restore FROM production to developpement.  The whole process is coded and takes around 2...

    November 21, 2006 at 8:22 am

    #673231

  • RE: Datafile Size

    IIRC the server can hold around 32676 databases where all of those could containt ±1 M terabytes of data. That's more or less 32 000 000 000 000 000 000 000 Bytes...

    November 21, 2006 at 8:20 am

    #673228

  • RE: Alter Index rebuild

    CREATE PROCEDURE dbo.REBUILD_INDEX

    AS

    DECLARE @tablename VARCHAR(255)

    DECLARE @tableowner VARCHAR(255)

    DECLARE @tablename_header VARCHAR(600)

    DECLARE @sql VARCHAR(600)

    DECLARE tnames_cursor CURSOR FOR

      select 'tablename'=so.name,

       'tableowner'=su.name

      from dbo.sysobjects so

        inner join dbo.sysusers su on so.uid = su.uid

      where so.type = 'U'

    open tnames_cursor

    fetch next from tnames_cursor into @tablename,...

    November 21, 2006 at 7:36 am

    #673204

  • RE: Clearing up objects from cache selectively

    I think there's a deeper problem here.  You need a Developpement and QA server.  On that machine you'll be able to audit perdormance and test whatever you like.  You'll also...

    November 21, 2006 at 7:32 am

    #673200

Viewing 15 posts - 10,996 through 11,010 (of 18,923 total)