Viewing 15 posts - 466 through 480 (of 1,069 total)
vijay82 (7/22/2011)
My question is if i am having dbo owner permission then i have to access every table but why i am unable to acccess the some of the tables.
Eventhough...
July 27, 2011 at 2:17 am
logicinside22 (7/26/2011)
Thanks Suresh .I have sql 2008 R2 Ent installed on my laptop.
I suggest you intall at least two intances to practice Replication, Mirroring, Log-Shipping, TDE-Backup/Restore, Linked Server, etc.
July 26, 2011 at 2:40 am
adb2303 (7/26/2011)
...I suggest you download SQL Express and start learningAndrew
I suggest, for learing 120 days trial edition (= Enterprise) should be used as exam covers all the editions and features....
July 26, 2011 at 2:12 am
which is the good books to review ?
MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 Implementation and Maintenance (Pro-Certification) by Mike Hotek
what type of question they asked?
Above book...
July 26, 2011 at 2:06 am
You can setup Transactional Replication for this purpose.
July 25, 2011 at 6:17 am
rathod.balu (7/21/2011)
...Ideally , we must not get this warning due to row over flow concept of the SQL 2005 however i am still gettiung this issue.
Row overflow happens only for...
July 21, 2011 at 4:05 am
forsqlserver (7/21/2011)
Thanks,There are two categories Maintenance Plan Task and General from which category I should choose it.
You can select from any category. Both are same.
Don't hesitate to experiment in a...
July 21, 2011 at 3:38 am
TST1 (7/20/2011)
I'm having a bit of trouble working out how I can script this to get all the databases offline apart from the system dbs.
exec sp_MSforeachdb 'USE ? IF DB_NAME()...
July 21, 2011 at 3:33 am
Maintenance Cleanup Task
July 21, 2011 at 3:27 am
forsqlserver (7/20/2011)
... so that I need not to check continuosly the disk space.I dont want to do daily login and delete the old backup files.
You don't have to manually delete...
July 21, 2011 at 2:46 am
What do you get when you run the following query?
select * from sys.servers
May be your server name was renamed.
May be use you can fix it using sp_dropserver and sp_addserver
July 21, 2011 at 1:02 am
BinaryDigit (7/20/2011)
.. but becasue caching will mainly help select queries is it ok to have inserts and updates not as stored procs?
I don't agree with.
Are you talking about the...
July 20, 2011 at 11:32 pm
use msdb
go
exec sp_add_job @job_name = N'MyJob'
go
exec sp_add_jobserver @job_name = N'MyJob', @server_name = N'MyServer'
go
exec sp_add_jobstep @job_name = N'MyJob', @step_name = N'MyJobStep', @subsystem = N'TSQL', @database_name = N'MyDatabase', @command = 'EXECUTE dbo.spMySP'
go
exec...
July 20, 2011 at 11:13 pm
If you need only database size, you can query sys.master_files directly. No need to use sp_msforeachdb.
Hint:
select (size*128.0)/1024 'Size (MB)', * from sys.master_files
July 20, 2011 at 10:03 pm
What is the purpose of this script?
I think you can achieve it with sys.database_files
July 20, 2011 at 4:18 am
Viewing 15 posts - 466 through 480 (of 1,069 total)