Active Server Pages(ASP) - Data Base Questions - Part II

[VelMurugan]

Active Server Pages(ASP) - Data Base Questions

What are the limitations of MSDE?

Where do I get MSDE?

How do I get the result of dynamic SQL into a variable?

What are the valid styles for converting datetime to string?

Why can't I access a database or text file on another server?

Why does RecordCount return as -1?

How do I retrieve the description property of a column?

Why do I get 80040E21 errors?

How do I get a list of Access tables and their row counts?

How do I reclaim space in SQL Server?

Why do I get 800A0E7D errors?

How do I load text or csv file data into SQL Server?

How do I monitor when data changes in a SQL Server table?

How do I solve 'ADO Could Not Find The Specified Provider'?

Why do I get 'Argument data type text is invalid for argument [...]'?

How do I use GETDATE() within a User-Defined Function (UDF)?

What is this 'Multiple-step OLE DB' error?

Why can't I use the TOP keyword?

Why is my app slow after upgrading from SQL Server 7 to 2000?

What are reserved Access, ODBC and T-SQL keywords?

Why do I get 800A0E78 errors?

Why do I get 800a0cb3 errors?

What datatype should I use for my character-based database columns?

Why do I get 80040200 / 80040514 / 800A0E7A errors?

Why do I get 'Syntax Error in INSERT INTO Statement' with Access?

How do I access MIN, MAX, SUM, COUNT values from SQL statements?

How do I hide system tables in SQL Server's Enterprise Manager?

Why can't I use LIKE '%datepart%' queries?

How do I show all the triggers in a database?

How do I limit the number of records returned in my resultset?

How do I show all the primary keys?

How do I deal with an apostrophe (') in a SQL statement?

How do I solve 'Could not find installable ISAM' errors?

What does "ambiguous column name" mean?

Why does EM crash when I get an error in a stored procedure?

I get "Login failed for user '\'." in SQL Server, why?

How do I prevent my ASP pages from waiting for backend activity?

Why do I get 80040e31 / 'Timeout Expired' errors?

Why is Enterprise Manager slow at expanding my database list?

How do I get the latest version of the JET OLEDB drivers?

Should I use recordset iteration, or GetRows(), or GetString()?

How do I upsize my MSDE database to full-blown SQL Server 2000?

How can I tell which version of MDAC I'm running?

How can I learn more about undocumented SQL Server stored procedures?

How do I list the parameters (and datatypes) for a stored procedure?

Why can I not 'open a database created with a previous version...'?

Why do I get 'object could not be found' or 'invalid object name'?

Why is tempdb full, and how can I prevent this from happening?

Why am I having problems with SQL Server 2000 SP3?

Where else can I learn about SQL Server?

Why can't I install SQL Server on Windows Server 2003?

What datatype should I use for numeric columns?

What are the main differences between Access and SQL Server?

What should I choose for my primary key?

What are the capacities of Access, SQL Server, and MSDE?

How do I ignore common words in a search?

Why do I get database-related 80004005 errors?

How do I get a list of SQL Server tables and their row counts?

How do I use a variable in an ORDER BY clause?

How do I manage SQL Server / MSDE?