Q&A » Computers & Internet » Programming

Can't find the answer? Ask

Ask

Submit Articles

Publish your articles and reach thousands of readers worldwide.

Publish

■ Welcome Guest, LogIn

■ Create a new account

■ Login with

Q&A » Computers & Internet » Programming » SQL

Articles

Q&A

Unanswered

Error SQL 2008 Express : Login failed for user 'db_user_11'. Reason: Failed to open the explicitly specified (1 answers)

i found this Faillure "error" in the windows 2003 log, it is caused by sql server 2008 express and accurs once a day : SQL 2008 Express : Login failed for user 'db_user_11'. Reason: Failed to open ...

Unable to open the physical file ... Operating system error 5 failed to retrieve text for this error. Reason: 15105 (2 answers)

i get this error when tring to open the database with visual studio (server explorer), run the website or even when trying to attach the database on the Sql Manager 2008 Unable to open the physica ...

SQL 2008 Client Connectivity SDK and SQL Client Tools SDK documentation (1 answers)

how to use SQL 2008 Client Connectivity SDK ? and where's the SQL Client Tools SDK documentation ?

Ms Sql Express 2005/2008 multi instance CPU and memory utilization (1 answers)

there is a limit of 1 Cpu and 1 GBof memory that can be used in sql, Sql Express 2005 or 2008 edition or advanced edition, the question is that limitation is for all the computer (server/machine) ...

Sql primary key vs. Index (3 answers)

when i set a field as a primary key does it become automatically an index or do i need to recreate an index for that field ?

Delete sys.dm_exec_query_stats queries cache (1 answers)

how to delete the cacheded queries in sys.dm_exec_query_stats, i want to clear the contain of dynamic management view sys.dm_exec_query_stats without restarting the SQL Server. thanks

total_elapsed_time in sys.dm_exec_sessions (2 answers)

what is the significance of total_elapsed_time in sys.dm_exec_sessions, what unit is used (is it milliseconds?)

Reorganise index and Rebuild Index (Sql Server Maintenance plan) (2 answers)

what's the difference between Reorganise index and Rebuild Index in Sql Server Maintenance ?

SqlDataSource & FormView always generates NULL value exception (1 answers)

it's very strange, i use a Formview to insert a data into an SQL express database, the Formview SqlDataSource always generates ans error "Cannot insert the value NULL into column 'adu', table 'Hel ...

SQL Server 2005 (1 answers)

Hi I would like to know if dual Y Axis is possible with SQL Server 2005 charting capabilities?

SQL Datetime and Datetime2 datatypes in SQL 2008 (1 answers)

in sql server 2008 there is 4 new types date, time, Datetime and Datetime2. what's the difference between the Datetime and Datetime2 datatypes in the new SQL server 2008?

The log scan number XXX passed to log scan in database - Sql Database error

When i try to attach the ms-sql database file (.mdf & .ldf) i get this error : The log scan number (1356:452:10) passed to log scan in database it's a small database but very important, the databa ...

SQL 2008 : Saving changes is not permitted. The changes you have made require... (1 answers)

how can i bypass this error in Sql Managment studio 2008 : "Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either ma ...

How we must use nvarchar/varchar and nchar/char data types when creating a SQL table? (2 answers)

When I must use this data types nvarchar and nchar instead of varchar and char? What is the advantages and the disadvantages?

» Connection