Microsoft SQL Server 2005. I cannot login to the server. I am getting 2 errors. Login Failed for user Error: 18456, and Shared Memory Provider, error: 0 - No process is on the other end of the pipe...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2334...
I have an MDF file with no log. I did the trick whereby you create a database with the same file info, shut down SQL, then copy over the MDF and restart SQL. The current status of the database is s...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2343...
I would like to find a way to convert Access SQL to SQL Server 2005 syntax. I currently have a SharePoint site that uses GridView boxes that displays data using SQL stored procedures but at the sam...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2369...
Hello,
I have a stored procedure which is trying to import data from one table to the another. It starts by creating a cursor and selecting the data it needs. That part, and the cursor, work f...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23759120.html
Hi,
I am trying to create a partion function, group and scheme. I seem to run into an error while creating the Scheme.
Volume of data expected each month is 4+ million.
Here are the deta...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2352...
I need to write a query that will return the sum of a field for all records in the previous month. The table has id, date, and quantity.
I can't figure out the code for the dates, I have no prob...
http://www.experts-exchange.com/Microsoft/Applications/Q_23356205.html
Zones:
MS SoftwareDate Asked: 04/26/2008 Points: 500 Comments: 3
I have data which is represented below:
OwnerBarcode ServerName OSEOL OperatingSystemName OwnerPercent
01404 ABOS54 False AIX 5.3 0.50
13561 ABOS54 False AIX 5.3 0.50
04039 ADAL24 True AIX 5....
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23763104.html
I have tried DB_DATE and DB_TIME, but both give me an error that the data was not converted due to truncation. I have set the error to "Ignore Failure" for truncate.
How can I get this "2008-10-...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2391...
