Viewing 15 posts - 541 through 555 (of 1,069 total)
icemannz (6/2/2011)
June 3, 2011 at 4:57 am
select * from sys.server_principals where type_desc = 'WINDOWS_GROUP'
May 25, 2011 at 2:17 am
RaviShankar1234 (5/23/2011)
... changes that have happenes to the SQL Server Jobs.
I don't think SQL Server stored all the changes that you make to a job. I think it stores only...
May 23, 2011 at 10:24 pm
ps_vbdev (5/5/2011)
In relation to users what is the difference between adding users in
When you see the list of Logins and Users in the UI, they look similar and may...
May 23, 2011 at 2:21 am
Please don't post the question in many places.
http://www.sqlservercentral.com/Forums/Topic1113147-391-1.aspx
May 23, 2011 at 2:13 am
There is no SQL Server Agent for Express edition.
See whether you can use Windows Scheduler.
Or use some other edition such as Standard edition.
May 23, 2011 at 2:10 am
Check FileStream in the test environment.
It has benefits of storing the picture (binary data) in the database as well as disk file.
May 22, 2011 at 10:18 pm
What error do you get when you try to execute dbo.sp_test?
I think you belong to different schema and sp_test exists in it.
May 20, 2011 at 2:11 am
Database snapshot is entirely different from backup.
When you take database backup, it will have all the data pages of the database.
When you create a snapshot, it's file size is 0...
May 19, 2011 at 6:11 am
Coolganny (5/11/2011)
Will the drop writes all the data (columns dropped) to log file?
Let...
May 19, 2011 at 1:10 am
In case of replication data should match between publisher and subscriber. By data, I mean number of rows and columns values.
(Replication validation checks for row count and checksum.)
There many be...
May 18, 2011 at 10:09 pm
I think sys.dm_os_performance_counters DMV returns performance counters related SQL Server only.
Non-SQL Server performance counter such as LogicalDisk Avg. Disk Sec/Transfer, Network Interface Bytes Total/Sec are not returned by this DMV
May 18, 2011 at 5:49 am
Fact and dimension tables are normal SQL Server database tables.
So, open SSMS (SQL Server Management Studio). Connect to the server VABCDEFxx:xxxxx (I think it is port number, so use colon...
May 18, 2011 at 5:37 am
Don't add SQL Server or SQL Agent service account to Local Administrator group.
Use SQL Server Configuration Manager to manage the sevrvice accounts. It grants the reqired minimum privilages to the...
May 18, 2011 at 3:24 am
I don't remember any table where that information is stored.
I think you have take care of it yourself.
May 18, 2011 at 12:27 am
Viewing 15 posts - 541 through 555 (of 1,069 total)