Viewing 15 posts - 44,356 through 44,370 (of 49,571 total)
samsql (9/21/2008)
Also try this.....DBCC CHECKTABLE('audit_record',REPAIR_FAST) can not fix this problem.
DBCC CHECKTABLE('audit_record',REPAIR_ALLOW_DATA_LOSS)
Do not, do not, do not run repair as the first thing tried when dealing with corruption. It should be...
September 22, 2008 at 1:23 am
sp_readerrorlog will show you the current error log for the server as a resultset.
The error log's not stored in a table so there's no direct query. It's a file (called...
September 22, 2008 at 1:20 am
What's the recovery requirements for that database? If the DB crashes at 1pm, is it acceptable to restore to the last full backup?
If not, then you need to run transaction...
September 22, 2008 at 1:17 am
shishirbabel (9/21/2008)
What my main point is that i am not sure that which indexing to use to make sure that database responds in a very fast...
September 21, 2008 at 2:01 pm
Pleasure.
September 21, 2008 at 1:49 pm
You can use SQL profiler to capture all the commands that are run against a server. That won't tell you what rows were affected, it will just give you the...
September 21, 2008 at 1:47 pm
Yeah, if the DB is using features that were deprecated in SQL 2000 and removed in SQL 2005. They'll still work in compat mode 80
Old style joins come to mind...
September 21, 2008 at 1:46 pm
shishirbabel (9/21/2008)
Which type of indexing to be used for large databases having more then 100 tables and a capacity to hold more then 10,000,00 records in the system ?
That's...
September 21, 2008 at 1:36 pm
YSLGuru (9/21/2008)
September 21, 2008 at 1:26 pm
Versions of SQL 2005 prior to SP2 don't run properly on Vista and you have RTM there.
Can you download the SP2 version of express and install that over the version...
September 21, 2008 at 1:17 pm
Please connect to the edition that you're trying to create the diagrams on and run the following:
select @@version
September 21, 2008 at 11:58 am
Update all statistics after you move to 2005, run a DBCC updateusage and I would recommend a CheckDB as well.
September 21, 2008 at 10:22 am
If you're running 2005 on Vista, being the machine's admin does not guarantee that you are sysadmin in SQL server. You'll have to explicitly add yourself as admin to SQL.
If...
September 21, 2008 at 10:11 am
Nope.
That's true of most things in SQL. Once they're deleted, they're gone.
September 21, 2008 at 8:41 am
Viewing 15 posts - 44,356 through 44,370 (of 49,571 total)