Viewing 15 posts - 166 through 180 (of 497 total)
RBarryYoung (2/21/2010)
I haven't checked it out specifically, but I believe that you would want a DDL trigger for CreateIndex in your database.
Yep, you would have a DDL trigger on your...
February 21, 2010 at 2:27 pm
It looks like my only option would be DDL trigger...
February 18, 2010 at 11:44 pm
Lowell (2/18/2010)
Roust_m (2/17/2010)
Hi,I want to give a user permissions to creata any object within a schema, BUT indexes, as well as read/write/execute, etc.
Is there a way to do this?
Thanks.
i don't...
February 18, 2010 at 5:56 pm
Question to be answered: How would you deal with weeks where you don't have data collected on Sunday?
Ideally I would like to take the database size and growth over two...
February 11, 2010 at 11:19 pm
lmu92 (2/6/2010)
Would you mind sharing what you've tried so far and where you got stuck?Did you have a look at the articles Jack referred to?
Sorry I've gone missing. I've...
February 10, 2010 at 8:39 pm
GilaMonster (2/9/2010)
Roust_m (2/8/2010)
February 9, 2010 at 7:10 pm
GilaMonster (2/8/2010)
February 8, 2010 at 10:26 pm
Ups... It looks like I found it out: you can add the counter for the mount point directly.
January 13, 2010 at 9:37 pm
RBarryYoung (12/10/2009)
Why not re-script them into a single file?
This is the process, they have to come from TFS, not from development database.
Besides, I don't want to re-script them all, only...
December 10, 2009 at 3:53 pm
Ok, the starting point for me is when all the objects, tables, FKs, triggers, SPs, etc are scripted into separate files. This can't change, as it is part of...
December 9, 2009 at 3:51 pm
Ok, found it out, the weird error happens because of the use of master database name in the execution string:
set @s-2 = 'DECLARE @fn sysname
SELECT @fn = [name] FROM '...
December 8, 2009 at 6:28 pm
Well I am dealing with very small number of records, something like 30+ so I am not much concerned about performance. Especially having the fact that the job runs...
November 23, 2009 at 11:58 pm
SJTerrill (11/23/2009)
Well, if your LIKE search isn't using a wildcard, could it not use = 'HomeRun_ZYX' ? If you're not searching string content, that is.
Sorry, did not understand this one.
November 23, 2009 at 11:30 pm
SJTerrill (11/23/2009)
Danger, Roust... your LIKE statement isn't using the % wildcard. Something deeper going on here?
What danger? My databases are called similar to HotDogAUXYZ for Australia, HotDogDEXYZ for Germany...
November 23, 2009 at 11:16 pm
Viewing 15 posts - 166 through 180 (of 497 total)