|
|
-
|
|
Task List or Ctrl+\,T. It will appear as following.We ca......
|
|
-
|
|
Problem:
One day when i was creating a new database, i was notified as "Could not obtain exclusive lock on database 'model'. Retry the operation later" and i could not able to sucees to created that database.
The error looks,
TITLE: Microsoft SQL Server Management Studio
Create failed ......
|
|
-
|
|
<div trbidi="on" style="text-align: left;" dir="ltr">
In past, during development of the stored procedures, I have used XML or VARCHAR datatype with comma seperated data values as parameter of stored procedure. This was the option before SQL Server 2008 arrived whenever we required to used it.
<br......
|
|
-
|
|
I hope you already read my previous post for the "Login failed for User" - Reason 1. And you have very idea on that how user was failed due to default database assigned to associated User. After default database changed User was success to login in SQL Server instance.
If you have not read that......
|
|
-
|
|
I have just created papers on paper.li for the SQL Server updates and socialized it. It giving the daily headlines of the posts and technology news for the SQL Servers by categorized with various tags like Headlines, Technology , #JustLearned and all other SQL Server daily publications.
It dail......
|
|
-
|
|
Before a some weeks ago i have posted for some enhancement like Zooming with the query analyzers and also with outputs as well. Here i would like to show the same but some another things also. In this enhancement SQL Server Denali introduces some of changed in query editors. List of changes: 1. Cha......
|
|
-
|
|
0 )
DROP TABLE CTEMaxLevelTab
GO
CREATE TABLE ......
|
|
-
|
|
0 )
DROP TABLE HierarchyTab
GO
CREATE TABLE HierarchyTab
(
NodeId INT IDENTITY(1, 1)
,NodeDepth VARCHAR(100) NOT NULL
,NodePath HIERARCHYID NOT NULL
,Node......
|
|
-
|
|
I have used Zoom feature with Windows which is inbuilt feature of windows itself or using some external tools but never with SQL Server.
SQL Server Denali arrived with one more feature and that's Zoom/Magnify. I found it somewhat playing with analyzer.
Let's look for the below image for this ......
|
|
-
|
|
Sometime we are using triggers to get old and new values or new values for the historical data to save in another table. So we can get inserted, updated and deleted data using triggers.
But one amazing feature "Output" clause. ...
|
|