In SQL Server 2005, how do I display all permissions a user/login has? Is there a stored procedure to do this?
In SQL Server 2005, how do I display all permissions a user/login has? Is there a stored procedure to do this?

Answer Question   |  April 21, 2008  11:36 PM
SQL Server 2005, SQL Server administration

Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?
Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?

Answer Question   |  March 5, 2008  11:33 PM
SQL Server 2005, Windows Server 2003

Equivolent SQL Server function for Access DoCmd.TransferText
I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?

Answer Question   |  March 5, 2008  4:36 PM
DoCmd.Transfer, Microsoft Access, SQL Server, Stored Procedures

execution plan is same even though it takes 10 times longer to run
I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be? Thank you!

Answer Question   |  March 10, 2008  5:07 AM
Execution Plan, Indexes, Performance/Tuning

29 Feb incorrect in DateAdd and GetDate command
Hi, Does anyone know Why the day of date different ? when i used : select GetDate() –> It’s Return 2008-02-29 11:01:45.310 and then when used : select DateAdd(yyyy,543,GetDate() ) —> It’s return 2551-02-28 11:01:45.310 My SQL Server is MS SQL Standard Edittion VERSION 6.5 Anyone have any ideas ?

Answer Question   |  February 29, 2008  4:53 AM
SQL Server 2000, SQL Server development

Settng Memory Sql Server 2005 SP2 64Bit
Hi I’ve a SQL Server 2005 sp2 64bit , i have to set memory and my server has 12gb fisical memory and 20gb paging file, what is the best pratices to set sql server memory for best performance? Thank You Best Regards Vincenzo

Answer Question   |  March 2, 2008  4:19 PM
SQL Server, SQL Server 2005, SQL Server performance tuning

Stored Procedure for dropping indexes
I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another strored procedure that takes a [...]

Answer Question   |  March 3, 2008  4:04 PM
DROP, Indexes, Restore, Stored Procedures

Using SELECT statements
Can we get the number of saturdays in any month using a SELECT statement(i.e without creating a table or function)? If so, can you give me the logic?

Answer Question   |  February 28, 2008  9:48 PM
Oracle, Oracle development, SELECT statement

Msg 102, level 15, State 1, Line 102
I get this with an ‘Incorrect syntax’ messasge when I run a stored procedure. if I run the ‘offending’ code in isolation it works fine. If I tidy the code (e.g. remove line feeds etc), the error ‘moves’ to a different location. HELP!

Answer Question   |  January 22, 2010  12:55 PM
SQL Server, SQL Server errors, Stored Procedures

SQL MERGE
I have a view like below generated from my time and attendance software. staffNo EmployeeName title TransactionType Cdate time 556 JOHN WEB DEVELOPER IN ENTRY 24/01/2008 13:47:30 556 JOHN WEB DEVELOPER OUT ENTRY 24/01/2008 16:38:33 556 JOHN WEB DEVELOPER OUT ENTRY 24/01/2008 16:40:03 556 JOHN WEB DEVELOPER IN ENTRY 26/01/2008 10:05:39 556 JOHN WEB DEVELOPER [...]

Answer Question   |  March 2, 2008  10:33 AM
SQL, SQL MERGE

SQL 2000 Reporting Services – Using embedded code to guide user on input parameters?
I’m working on a report which has these input parameters: StartDate (textbox, data type is datetime) EndDate (textbox, data type is datetime) AccountNumber (dropdown, data type is string) I need to set up logic where if the user viewing the report has input only date values, they’ll be prompted to select an AccountNumber, or if [...]

Answer Question   |  September 20, 2008  1:23 AM
Microsoft, Reporting Services, SQL Server 2000

Performance Tracking of Stored Procedures
we have a current system where a COBOL stored procedure is called by a .NET application. This COBOL SP then calls multiple COBOL subprograms which perform calculations and update files and then eventually return a value to the .NET app. We have a limitation in tracking the performance of each called subprogram, due to the [...]

Answer Question   |  February 27, 2008  7:07 PM
.NET applications, COBOL, COBOL stored procedures, CPU usage, MIPS, Performance management, Performance/Tuning, Stored Procedures

Fixing a corrupted file
I have a 2801 router, but the Nvram file is corrupted. When we try to copy the Running config is not working. The command I use is the following: copy running-config startup-config The error says it cannot save it. I don’t know what’s wrong. What should I do? Do I need to download the new [...]

Answer Question   |  February 27, 2008  9:42 PM
Config, File, Networking, Routers

RPG with Dynamic SQL Problem – SQLCOD 501/312
I’m trying to do simple dynamic SQL in a program to select records for a subfile but it doesn’t seem to be working. sSql = ‘SELECT orderno FROM ordhdr ‘ ‘WHERE custno = :scSrchCust ‘; following this I have: exec SQL CLOSE @Orders; exec SQL Prepare Stmt from :sSQL; exec SQL Declare @Orders SCROLL CURSOR [...]

Answer Question   |  February 25, 2008  12:21 PM
Dynamic SQL, RPG, SQL, SQLCOD

Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded
Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded

Answer Question   |  March 2, 2008  12:00 PM
SQL Server 2000, SQL Server 2005, SQL Server installation

Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005
Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005

Answer Question   |  March 2, 2008  11:33 AM
SQL Server 2000, SQL Server 2005, SQL Server replication

Replication in SQL Server 2005 deleting records
We just converted from SqL 2000 to 2005. We were replicating from 2 instances on the same server every 30 minutes. A record from Intsnace A was copied to Instance B, then the record in A was deleted. Worked great for years. Now with 2005 it is deleting the records on B on the second [...]

Answer Question   |  February 22, 2008  7:41 PM
Replication, SQL Server 2000, SQL Server 2005

Backup Programmability in SQL Server 2005
How can I backup the Programmability (functions, triggers stored procedures etc.) as part of a schedule job? Do I need to write code or can I use the wizard?

Answer Question   |  March 2, 2008  3:11 PM
Backup, SQL Server 2005, SQL Server backup

How to Encrypt a Column in sql server 2000/2005
How to Encrypt a Column in sql server 2000/2005 i.e i need something like this @OriginalValue = ‘Original Value’ @EncryptedValue @Key int set @Key = ’123#$2hj$dfgh*67kjugd45j45s4agd’ –any unique key value for encrypting and decrypting set @EncryptedValue = fn_Encrypt(@OriginalValue, @Key) insert into table_Master (name_Master) values (@EncryptedValue) for selecting select fn_Decrypt(name_Master, @Key) from table_Master how to do [...]

Answer Question   |  May 8, 2012  6:13 AM
Encryption, SQL Server

Connecting from VB6 to a remote Oracle Database
We are a SQL 2000 Database shop using Visual Basic 6.0 & Windows 2003. I need to develop an application that can access an Orcale database on a remote system (sight to sight VPN in place) using SQL. I retreived some information yesterday that enabled me to construct the connect statement in our application. However [...]

Answer Question   |  March 6, 2008  3:41 PM
Oracle, SQL Server, SQL Server 2000, SQL Server 2005, VB, Visual Basic 6