Description:
Microsoft's SQL Server and related products.
|
|
|
Error 262 create database
|
| |
Hi, I have this problem: I use my net user to connect in sql server but when I'm doing this operation I receive a message box: Error 262 Autorization create database no possible in master database. Can you help me? Thanks nick
|
|
|
How to control number of users in a database?
|
| |
Hi, I use VB 2008 as front end, SQL Server 2005/2008 as back end, I want control number of cucurrent users log on to the database, I am trying to use a stored procedure, but it did not work. Is this possible? Please help. Thanks Kai
|
|
|
MS Access 2000/XP Training on CDs/Videos
|
| |
Need a Checking Account Today? 100% all access approval, debit MasterCard, write checks online, no ChexSystems, credit checks or security deposit. [link] Verizon Business DSL Get 12 months for the price of 10 and great rebates on online orders. [link] Internet Access - Now Only $5.47... more »
|
|
|
SSMS indexes
|
| |
Under SSMS where can one find the list of indices? I can see Stored procedures under Programmability. Is there any place where I can see the list of indexes. Apologies, if this is a stupid question.
|
|
|
T-SQL
|
| |
Hello, I need to write a stored procedure that has two different user connections to two different databases. Both db's are on the same one server. Is this possible to create using Transact-SQL commands in a stored procedure? Thanks :-)
|
|
|
Stored procedure
|
| |
Can someone help me get the right data out... I want to compare last weeks Table Diary9-22 to this weeks Table Diary9-29 to see if the same PAN (field name) are in both records How would I write this?
|
|
|
SSMS - setting root of Object Explorer
|
| |
Hello. I'm slowly coming to terms with the SQL Server Management Studio 2005. I've really tried, but cannot figure out how to restrict the SSMS to only look at one database. Ideally what I want is for SSMS to open, connect to a server and set a specified database as the root of the Object Explorer - this would... more »
|
|
|
Accessing the call stack via TSQL
|
| |
Hi I was wondering if anyone new how to access the call stack information via TSQL I'm currently in the process of migrating an application from Oracle to Sql Server 2005 There is a long running batch process where we currently catch the error and collect the information of the call stack and allow the... more »
|
|
|
Application Roles and SQL Server 2005 - DDL?
|
| |
Hello group, We have recently come up with a problem where SQLServer 2005 differs from 2000. We have an application role, which needs to run DDL to alter tables etc. The documentation for 2005 states quite clearly that application roles cannot be made members of built in roles like db_owner or db_ddladmin - which proves to be the case, but this was possible in... more »
|
|
|
SQL Server Management Studio question
|
| |
Hi all, Whenever I open a new file in the Studio, I need to type in a long ugly statement to open a symmetric key. I keep this saved in a file and paste it back there, but I don;t like this in particular, I was wondering maybe there is a better way, like have a new file template or maybe assign some key /macro kind of thing.... more »
|
|
|
