Home > Microsoft SQL Server
Microsoft SQL Server
Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.
Text wont show on page, but nvarchar will
Hi, we are using sql version 7 we have a table that has a column for large amount of text (like an article) we used text for the datatype and for some reason the text just wont show on the page or in the text box on the edit form. All we ...
Hi, we are using sql version 7 we have a table that has a column for large amount of text (like an article) we used text for the datatype and for some reason the text just wont show on the page or in the text box on the edit form. All we ...
answer(2) view(452) status(
)
)
ASP.NET & SQL Server (Getting Started)
Good day everyone. I'm new to SQL/ASP.NET and the Visual Studio environment. I'm trying to get a simple example to work from a book that I'm learning from: "Moving to ASP.NET: Web Development with VB.NET" I have SQL Serv...
Good day everyone. I'm new to SQL/ASP.NET and the Visual Studio environment. I'm trying to get a simple example to work from a book that I'm learning from: "Moving to ASP.NET: Web Development with VB.NET" I have SQL Serv...
answer(3) view(209) status()
)
need dba interview question & answers
hi I am preparing for an interview for the post of sql server 2000 DBA. if anybody have some questions & answers for this so please send me on URL Thanks
hi I am preparing for an interview for the post of sql server 2000 DBA. if anybody have some questions & answers for this so please send me on URL Thanks
answer(1) view(412) status()
)
Updating multiple databases
Hello, I'm writing to see if anyone is familiar with a tool that can update SQL Server code (i.e. stored procedures, views or table modifications) throughout multiple databases. Currently we use Query Analyzer to step through every dat...
Hello, I'm writing to see if anyone is familiar with a tool that can update SQL Server code (i.e. stored procedures, views or table modifications) throughout multiple databases. Currently we use Query Analyzer to step through every dat...
answer(1) view(170) status()
)
Downloading Databases...
May i know how shd i do if i am using ASP.Net, i had to create a link on 1 of my page so that the User can download a particular database out to their computers in excel (.xls) format
May i know how shd i do if i am using ASP.Net, i had to create a link on 1 of my page so that the User can download a particular database out to their computers in excel (.xls) format
answer(2) view(54) status()
)
Resetting Primark keys (ID)
Hey People First time user and SQL Server novice here. I've had to delete ALL records from a SQL Server database and the primary key in all of the tables was "Trip_id" which was an automatically generated numeric id. Now ...
Hey People First time user and SQL Server novice here. I've had to delete ALL records from a SQL Server database and the primary key in all of the tables was "Trip_id" which was an automatically generated numeric id. Now ...
answer(4) view(571) status()
)
All I want for the Holidays...
The feeling of the holiday season is in the air: people are whistling, the birds are migrating, and Old Jack Frost has decided to pay a visit once more. Of course, when you抮e in South Florida, that means that the air outside has dropped to ...
The feeling of the holiday season is in the air: people are whistling, the birds are migrating, and Old Jack Frost has decided to pay a visit once more. Of course, when you抮e in South Florida, that means that the air outside has dropped to ...
answer(0) view(443) status()
)
Single SQL stmt in asp
Please help. I currently have an .asp page that take way to long to complete because of my sql. Currently I am executing 3 stmts with a do/loop to get this data. I would like to count how many records are Y, but only if the latest entry...
Please help. I currently have an .asp page that take way to long to complete because of my sql. Currently I am executing 3 stmts with a do/loop to get this data. I would like to count how many records are Y, but only if the latest entry...
answer(2) view(261) status()
)
MS SQL Database Bad MOJO
We have a client that has a MS Sql 7 database who's drive array failed. Unfortuately, the array failed while the database was open. It had not been detached and reattached so as to be backed up. The previous tech led the company to believe ...
We have a client that has a MS Sql 7 database who's drive array failed. Unfortuately, the array failed while the database was open. It had not been detached and reattached so as to be backed up. The previous tech led the company to believe ...
answer(3) view(945) status()
)
Invalid object name with SQL db
Moved a SQL database to another server and now the website gives the following error. Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'active_users'. ...
Moved a SQL database to another server and now the website gives the following error. Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'active_users'. ...
answer(1) view(120) status()
)
Retriving Images and displaying on webpage
How do i retrieve images[.gif/.jpg] from database and displaying it on a webpage?
How do i retrieve images[.gif/.jpg] from database and displaying it on a webpage?
answer(3) view(534) status()
)
Please Help with SQL & Asp
I'm new to SQL, and some what new to ASP, I'm trying to create a Inventory database, I need to be able to have an asp connect to a sql database, and be able to add records, and delete records, also search, but i can't get a sql connectio...
I'm new to SQL, and some what new to ASP, I'm trying to create a Inventory database, I need to be able to have an asp connect to a sql database, and be able to add records, and delete records, also search, but i can't get a sql connectio...
answer(2) view(134) status()
)
Accessing mySQL from .NET
Hello all, We are planning to migrate an application written in Perl + mySQL to .NET + MS-SQL Server. The test machine now has SQL Server running. During the development phase in .NET, we would want to access the mySQL database which is ...
Hello all, We are planning to migrate an application written in Perl + mySQL to .NET + MS-SQL Server. The test machine now has SQL Server running. During the development phase in .NET, we would want to access the mySQL database which is ...
answer(0) view(324) status()
)
Contest Details
Space. The final frontier. Also, one heck of a challenge, when you抮e talking about hard drive space. It抯 a funny thing, when you think about it; in the age of 300GB hard drives we抮e still running out of space. Maybe it抯 because certain soft...
Space. The final frontier. Also, one heck of a challenge, when you抮e talking about hard drive space. It抯 a funny thing, when you think about it; in the age of 300GB hard drives we抮e still running out of space. Maybe it抯 because certain soft...
answer(0) view(482) status()
)
Sql Backup Problems
HI FORUM, I need u r help in backup of a sql database =>> PROBLEM 1 The following backup statement works fine on my local sql server BACKUP DATABASE [Acc] TO DISK = 'c:\bk1' WITH INIT (I use I/SQL tool / Sql Query Analyze...
HI FORUM, I need u r help in backup of a sql database =>> PROBLEM 1 The following backup statement works fine on my local sql server BACKUP DATABASE [Acc] TO DISK = 'c:\bk1' WITH INIT (I use I/SQL tool / Sql Query Analyze...
answer(1) view(120) status()
)
Can anyone recommend good SQL Server monitoring software?
I'm looking for software that will give me a quick overview of the state all my databases in SQL Server. Also, something that would notify me, through email etc..if there were any errors in the SQL Logs. Unfortunately we've recently had a...
I'm looking for software that will give me a quick overview of the state all my databases in SQL Server. Also, something that would notify me, through email etc..if there were any errors in the SQL Logs. Unfortunately we've recently had a...
answer(1) view(218) status()
)
Any recommendation for good SQL Server replication software?
I'm looking for software that does SQL Server replication. The current replication software that we use replicates corrupted databases. Which really defeats the purpose of replication. Anyway, I'm looking for software that will recognize...
I'm looking for software that does SQL Server replication. The current replication software that we use replicates corrupted databases. Which really defeats the purpose of replication. Anyway, I'm looking for software that will recognize...
answer(1) view(982) status()
)
SQL Mail
The SQL Mail can only work with Ms Exchange Server ? Can it just work with Ms Outlook alone ? And how the configuration and setting like ?
The SQL Mail can only work with Ms Exchange Server ? Can it just work with Ms Outlook alone ? And how the configuration and setting like ?
answer(3) view(348) status()
)
Veritas Backup Very Slow
Hi, Our backup to tape for both production servers is incredibly slow. This job used to complete in 10 hours and now, we are experiencing lags up to 60 hours and still they aren't complete. We are going to reboot the servers tonight, but...
Hi, Our backup to tape for both production servers is incredibly slow. This job used to complete in 10 hours and now, we are experiencing lags up to 60 hours and still they aren't complete. We are going to reboot the servers tonight, but...
answer(0) view(776) status()
)
transferring datetime data between databases
i'm trying to transfer existing tables to a new database. the tables i'm transferring from/to don't have the same structure/field names (trying to improve what i already have), so what i'm doing is opening a connection to both databases, ge...
i'm trying to transfer existing tables to a new database. the tables i'm transferring from/to don't have the same structure/field names (trying to improve what i already have), so what i'm doing is opening a connection to both databases, ge...
answer(6) view(521) status()
)
Syntax error in Stored Procedure
The code below gives me an Error 156: Incorrect Syntax near the keyword 'SELECT'. Any assistance is greatly appreciated. Thank you. INSERT INTO [program_management].[dbo].[ecr_evaluations] ( [ecr_id], [user_id], [aff...
The code below gives me an Error 156: Incorrect Syntax near the keyword 'SELECT'. Any assistance is greatly appreciated. Thank you. INSERT INTO [program_management].[dbo].[ecr_evaluations] ( [ecr_id], [user_id], [aff...
answer(2) view(549) status()
)
For XML Explicit..
Hello, I have 3 tables that i need to get data from them untill now i've used for xml auto but the problem that i need to build a xml document that look like this: I have tried Explicit, but i did'nt make it work untill now .. any other ...
Hello, I have 3 tables that i need to get data from them untill now i've used for xml auto but the problem that i need to build a xml document that look like this: I have tried Explicit, but i did'nt make it work untill now .. any other ...
answer(1) view(438) status()
)
errors in enterprise manager
has anyone encountered the following errors before: Could not open FCB for invalid file ID 8193 in database Error: 5180, Severity: 22, State: 1
has anyone encountered the following errors before: Could not open FCB for invalid file ID 8193 in database Error: 5180, Severity: 22, State: 1
answer(1) view(895) status()
)
MS SQL Exercises
http://sql.ipps.ru/?Lang=1
http://sql.ipps.ru/?Lang=1
answer(2) view(688) status()
)
Read all mails one by one
How can i read all the mails in my outlook 2000 inbox using xp_readmail. I am able to read only one mail. but when i am looping with xp_findnextmsg to read all the messages, the loop is not terminating and system is hanging my sample code...
How can i read all the mails in my outlook 2000 inbox using xp_readmail. I am able to read only one mail. but when i am looping with xp_findnextmsg to read all the messages, the loop is not terminating and system is hanging my sample code...
answer(0) view(626) status()
)
SELECT, IN statement
Can someone tell me how to use a variable with the IN statement? This works: declare @emp [varchar](20), @per [varchar](6), @seq [varchar](30) set @emp='025390' set @per='200401' set @seq='84' Selec...
Can someone tell me how to use a variable with the IN statement? This works: declare @emp [varchar](20), @per [varchar](6), @seq [varchar](30) set @emp='025390' set @per='200401' set @seq='84' Selec...
answer(1) view(1,004) status()
)
Fill a bimary field by Enterprise Manger
Dear all, I have created a table with a binary field. How can I store a pdf file into it by using Enterprise Manager? Thanks. Regards, Ivan
Dear all, I have created a table with a binary field. How can I store a pdf file into it by using Enterprise Manager? Thanks. Regards, Ivan
answer(4) view(451) status()
)
2 quickies......
2 quick questions for you: 1) Can you use SQL Query Analyser to output selected data from a query to a text file located locally? A little example would be great! 2) I want to use a query to select every 10th record from a table/query...
2 quick questions for you: 1) Can you use SQL Query Analyser to output selected data from a query to a text file located locally? A little example would be great! 2) I want to use a query to select every 10th record from a table/query...
answer(2) view(885) status()
)
Migrating database
Hi friends, How can i migrate from MS Access database(2000) to SQL server 2000 database. Is it possible? thanx in advance
Hi friends, How can i migrate from MS Access database(2000) to SQL server 2000 database. Is it possible? thanx in advance
answer(2) view(568) status()
)
MS SQL backup
Hi, I just joined a company and we have a MS SQL database for our website. We are looking for a automated way to backup the databse regularly. The problem is that the database is at the hosting server but we would like to place the backu...
Hi, I just joined a company and we have a MS SQL database for our website. We are looking for a automated way to backup the databse regularly. The problem is that the database is at the hosting server but we would like to place the backu...
answer(3) view(609) status()
)
Programming
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2008 by Infoqu. All rights reserved
Copyright 2007-2008 by Infoqu. All rights reserved