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?
Answer Question | March 5, 2008 11:33 PM
SQL Server 2005, Windows Server 2003
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
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
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
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
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
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
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
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
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
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
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
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
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
Answer Question | March 2, 2008 11:33 AM
SQL Server 2000, SQL Server 2005, SQL Server replication
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
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 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
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