Viewing 15 posts - 766 through 780 (of 860 total)
anshu84onnet (2/5/2009)
Hi to all please provide dump for sql server 2005 administration certification if possible..
SQL Server Books Online best dump
February 5, 2009 at 4:35 am
Assign the group to db_datareader fixed database role. Members of this role can read only data from all the user tables.
February 5, 2009 at 4:00 am
LogShipping is only used as a stand-by-server in which case one would be primary and the other as a secondary server which is a stand by server where it does...
February 5, 2009 at 3:55 am
If i understand your question correctly, make the primary key of the first table as a foreign key in the second table , PK-FK relationship maintains the data integrity and...
February 5, 2009 at 3:21 am
Use Master
Go
Alter database TEST_FILE
Modify file(name=TEST_FILE, filename='D:\test')
You should specify the full path:
Use Master
Go
Alter database TEST_FILE modify file(name='TEST_FILE', filename='D:\test.mdf')
Alter database TEST_FILE
modify file(name='TEST_FILE_log' filename='D:\test_log.mdf')
Once done check the changed path using:
SELECT * From...
February 5, 2009 at 3:09 am
How can i track who changed the permission out of 3 perosns who has sysadmin roles
Have you got default trace enabled on your server? You could check who changed the...
February 5, 2009 at 2:31 am
SET TotalView = (SELECT COUNT(Name) FROM SYS.SYSOBJECTS WHERE XType = 'V')
,TotalProcedure = (SELECT COUNT(Name) FROM SYS.SYSOBJECTS WHERE XType = 'P')
,TotalFunction = (SELECT COUNT(Name) FROM SYS.SYSOBJECTS WHERE XType...
February 5, 2009 at 2:15 am
samsql (2/4/2009)
As my manager wants it i have to do that as it recession time.....
Recession time?? How does that help??:cool:
Probably he is testing you, as advised if you maintain proper...
February 5, 2009 at 1:54 am
TotalFunction = (SELECT COUNT(Name) FROM SYS.SYSOBJECTS WHERE XType = 'FN' OR )
Don't you have to count total functions? Here you are counting only a scalar...
February 5, 2009 at 1:47 am
I have a job to rebuild indexes..this increases the transaction log size....so i want to truncate it...
How frequent do you rebuild your indexes. There will be heavy logging while rebuilding...
February 5, 2009 at 1:28 am
On top of the above questions can you post your queries that you are using to access your tables? any filters? How are you accessing your tables through stored procedures/ad...
February 5, 2009 at 1:21 am
It depends on your business requirement. Consult your company or your manager before scheduling any backups as it might lead to some overhead on production systems.
If you dont need...
February 4, 2009 at 11:42 am
It is really upto you what you want to specialise on.
In my opinion you can do MCITP for SQL 2005 and then later upgrade it to MCITP SQL 2008...
February 3, 2009 at 1:35 pm
shivani.suri2 (2/3/2009)
This table does not have entry for the active trace file which has been generated using SQL Server Profiler.
'STATUS' COLUMN...
February 3, 2009 at 3:44 am
am being stupid. This is what happens if i sit without a cup of coffee:P
try this :
SELECT * FROM sys.traces WHERE path='file-path'
if status=0 which means stopped
...
February 3, 2009 at 2:17 am
Viewing 15 posts - 766 through 780 (of 860 total)