Hi All, While creating Publisher on SQL 2000 I am getting error "Process could not access database ... of server...". I have checked the owner and every...
Hi All, I have made a few blog posts on generating subtotal/total rows as part of the query results, this week. These posts examine different options using...
Hi All, I have 10 partitions on a table. Now I want to remove 2 out those 10. I dont even want to save the data in those patitions. What's the fastest way to...
Hi, There is nothing so complicated about the LEN() function. But I observed a few interesting points about its behaviour in different cases. I have posted my...
Hi, I have been writing about the SET options of SQL Server and wrote about ANSI_NULLS and ANSI_WARNINGS. I was in the middle of a post that discusses SET...
Hi, SQL Server does not have built-in support for comparing two XML values and determine if the content is equal. I have posted a tutorial that creates a TSQL...
Hi, I wrote a TSQL function that returns the dependency chain of an object. The function reads data from system catalog views and implements a recursive query...
The Last free trail version 2.0 for trainig .......click here <http://jabr-fx-online-trading.blogspot.com/> [Non-text portions of this message have been...
Hi All, I need document to prepare the backup policy for my company;can any one provide the sample document for the same. Thanks and Regards Alok Gautam...
1)What is Forex? 2)How can i start trading Forex? 3)Who own Forex and where is it located? 4)What the working hours of Forex market? 5)What is margin? 6)What...
Hi I am writing a series of posts on performing recursive updates in TSQL. You can find the posts here: TSQL Lab 10 - Writing a recursive procedure to update...
Hi, As we all know, SQL Server limits recursion to 32 levels. I have written a post that demonstrates how to write a recursive procedure that can process more...
Hi, SQL Server 2005 introduced the XML data type. Thought the XML data type is designed to store and manage XML documents, it can be used to solve a number of...
Hi, I suppose, many of us have renamed stored procedures, views, functions and triggers several times in the past. Sometimes renaming such objects can give you...
Jacob, Where is the PASSÂ happening this year? Â With :))s Santhosh Kumar S.J - MCTS ReadMe @ sqlspy.blogspot.com ReadMe @ santhoshpakkangal.blogspot.com ... ...
Transforming rows to columns (PIVOT/CROSS TAB) and columns to rows (UNPIVOT) may be one of the common requirements that all of us must have seen several times...
Hi All, The server is in mixed mode authentication. we have removed Builtin Administrators account and sa has been removed. how can we reset the sa password...
Try to connect SQL Server with windows login and then go to change SA password. Nitin ... From: Shyam Sunder <shyam_k25@...> To: sqlcon@yahoogroups.com ...
I shared with you a few posts, last week, discussing recursive updates in SQL server. We discussed the example of an ecommerce application that needs to...
how come sa will remove , if already you have dropped buildin\Administrator.. very surprising .. ... From: kunal choudhary <nitin_mca_23@...> Subject:...
You must have noticed that I kept posting about recursive updates several times in the last few weeks. This is the last post in the series that demonstrates...
I hope NTauthority is still there. you can connect with account with SA permissions. Thanks -Virender M. MS, MCDBA, MCITP ... From: kunal choudhary...
SQL Server - Recursive CTE and Ordering of Hierarchical Result WE discussed Recursive CTEs in many of the previous posts. Most of the times we use a recursive...
Many of you must have found the OBJECT_ID() function very handy. It is particularly helpful to check the existence of an object. SQL Server 2005 added a second...
