Viewing 15 posts - 23,416 through 23,430 (of 26,490 total)
Charles Kincaid (12/1/2008)
Jeff Moden (11/29/2008)
Some folks store unknown or "open" dates as 99991231 so they don't have to check for null to see if an enddate has occurred in the...
December 1, 2008 at 11:37 am
To really help, we would need to see the structure for the table, view, and the code for the function(s) used in the view. Also some test data might...
December 1, 2008 at 11:25 am
After looking at the RESTORE DATABASE statement in BOL, I have to say no. You have to restore then shrink the database if you don't want the extra space.
December 1, 2008 at 8:59 am
Roger Abram (12/1/2008)
No real backups.... don't know how long this has been going on.
Rog
I have to focus on the above, does this mean you don't have regular backups being taken...
December 1, 2008 at 8:51 am
Good catch Gail. I didn't think of asking what compatibility mode the database was using.
December 1, 2008 at 8:46 am
I have to agree as well. Also, if you have the database using full recovery model, you should also be running regularly scheduled transaction log backups. That will...
December 1, 2008 at 8:43 am
Can you run the following code snippet in your database?
SELECT
object_id AS objectid,
index_id AS indexid,
partition_number AS partitionnum,
...
December 1, 2008 at 8:36 am
You should be able to find in the following location in the object browers in SSMS:
Databases\System Databases\master\Programmability\Functions\System Functions\Table-valued Functions
December 1, 2008 at 8:08 am
Simon Lidberg (12/1/2008)
December 1, 2008 at 7:58 am
I have to get in on this. Are you actually going to look at hiring a consultant to rewrite this procedure? If so, I'd like to make a...
December 1, 2008 at 7:50 am
Application roles aren't assigned to users.
From Books Online:
An application role is a database principal that enables an application to run with its own, user-like privileges. You can use application roles...
December 1, 2008 at 7:41 am
torpkev (12/1/2008)
I have a database that I do transaction log backups every 4 hours on, and nightly full backups. My transaction log's are normally in the <200k range,...
December 1, 2008 at 7:29 am
As I said, the final authority on what licensing you need is really with Microsoft. I'd contact them and explain your environment, and determine the proper licensing requirements for...
December 1, 2008 at 7:25 am
See, I knew someone would have a better solution. I know, here's my excuse, it's early and the family is decorating the Christmas tree and the fights are just...
November 30, 2008 at 11:25 am
dubem1 (11/30/2008)
it's my first post here. I hope someone will help me
I have a trigger fireing on inserting in table1
I have this query to duplicate some rows...
November 30, 2008 at 11:02 am
Viewing 15 posts - 23,416 through 23,430 (of 26,490 total)