|
|
-
|
|
Recently when i worked with SQL Server security, i encountered with one error while trying to modify 'SA' account properties. The exception details looks following,
Alter failed for Login sa. Cannot set a credential for principal 'sa'.
Also you can see the image below for the same.
......
|
|
-
|
|
Recently while working with database security, I learned database roles as how the each role used. Apart from the server level roles if we need to require to assign access/rights to particular databases level then we need to go through database level roles.
Following are the fixed database leve......
|
|
-
|
|
I experienced into one issues for database backups were failed. And this was due to space issues on disk drive. This disk drive is spacific to allocated for the database backups only. The space was eaten by this database backups a......
|
|
-
|
|
When we created a new database it will be created with default isolation level and that is "READ COMMITTED". If some update transactions are running in with table rows under READ COMMITTED isolation level, How can we get data from table in another session while running update transaction?
How c......
|
|
-
|
|
I have drafted all the new features and enhancements introduced by SQL Server denali CTP1 and CTP3. Multi Monitor Support is the new feature among them.
We can do with this feature:
1. Using this feature we can use multi screen of query analyzer or editor.
2. You can monitor separately it an......
|
|
-
|
|
Recently while working with SQL CLR functionality and created DLL for the SQL CLR.
But while registering this DLL in the database i got one surprised error.
Lt's show you the script so you have more idea. We have a script to register DLL as following,
SP_CONFIGURE 'clr enabled',1
GO
RECON......
|
|
-
|
|
After posting some snaps to configure transactional replication in sql server having publication server as distributor, i want to share some of the issue which i got during working with it.
You may also faced the same issue and got resolved as well. You can comment if you faced any other replic......
|
|
-
|
|
As i have started to learn new functions arrived by SQL Server Denali CTP3 version and i have posted some of them. You can learn Analytical functions, Conversion functions and String functions. You can also get the list of all the features coming in SQL Server 2011 CTP3.
Now diverting on this......
|
|
-
|
|
<div dir="ltr" style="text-align: left;" trbidi="on">
During development of stored procedures, i ran into one issue and this was due to not applied best practice of stored procedures practice and this issue comes mostly when we call stored procedures inside another one and so on, which are used in ......
|
|
-
|
|
I hope you may read my earlier posts for Analytical functions and Conversion functions which are introduced in SQL Server 2011 CTP3. You can also move on What's New of Denali CTP3 here. Here i am going to explain new string functions which are also arrived in this SQL Server 11 CTP3 version also. <......
|
|