Hi, i'm a long-time newbie to c#, and this question may be too obvious, so please forgive if i'm "doing it wrong." Using Visual Studio 2005 Pro, C#, SQL Server 2000 EE SP3. I have a stored proc that takes one input param and returns several output params pertaining to that input. I am also calling it successfully, and String.Format-ing...
Let's say at your job your boss says, That system over there, which has lost all institutional knowledge but seems to run pretty good right now, could we dump double the data in it and survive? You're completely unfamiliar with the system. It's in SQL Server 2000 (primarily a database app). There's no test environment. You might...
I'm working with a existing database and trying to write a sql query to get out all the account information including permission levels. This is for a security audit. We want to dump all of this information out in a readible fashion to make it easy to compare. My problem is that there is a bridge/link table for the permissions so there a...
This may appear a newbie question but forgive me I am new to the world of dot Net. I have to make a desktop application that connects to a local SQL Server database. However in some cases the same database will be running on a server which can be accessed via the internet. What is the best way to design such a program. Basically the pr...
What steps do I take? Any gotchas to be aware of or tips to enhance the IDE experience that are specific to SQL Server when using Emacs? ...
I'm executing several discrete queries in a single batch against SQL Server. For example: update tableX set colA = 'freedom'; select lastName from customers; insert into tableY (a,b,c) values (x,y,z); Now, I want to capture the result in a DataSet (from select statement) which is easy enough to do...but how do I also capture the "m...
I have been tasked with developing a solution that tracks changes to a database. For updates I need to capture: date of update old value new value field effected person doing change record id table record is in For deletes: date of delete person doing delete The title/description/id of record deleted. The tables I am tracking cha...
Does SQL Server's (2000) Soundex function work on Asian character sets? I used it in a query and it appears to have not worked properly but I realize that it could be because I don't know how to read Chinese... Furthermore, are there any other languages where the function might have trouble working on? (Russian for example) Thank you,F...
Is it possible to create a parameterized SQL statement that will taken an arbitrary number of parameters? I'm trying to allow users to filter a list based on multiple keywords, each separated by a semicolon. So the input would be something like "Oakland;City;Planning" and the WHERE clause would come out something equivalent to the belo...
Is it possible to do a cross table join in mysql spaning different tables? in different databases. This seem to be easily possible in MSSQL, and greatly speeds up data transfer? How about mysql, do you need to use a powerful IDE to achieve this? or do you have to write a program to do something like this? UPDATE tblUser SET tblUser.R...
I am currently migrating one of my clients sites to a windows server 2008 and SQL 2008 setup, but I am having massive problems with connecting to the database from the site. I have restored the database from a SQL 2k backup into the SQL 2008 server, I have setup the user correctly and can login as that user in management studio fine. I ...
I need to purchase SQL Server 2008 Standard edition, because it's features fit what I need. On the features page, it says it can handle 32,767 user connections, but how does that connect with CALs? What are CALs and how can they affect a project? ...
I attempted to update sql server 2005 with SP2. I get a failure due to not starting vss writer. When I go into services, I see that vss writer is not installed. (not even listed in services). When I check my other redundant servers, I see that vss writer service is installed. How do I add the service? ...
I'm using a SqlDataSource to populate my GridView, because the two seem to be so tightly coupled together. Since this grid shows results of a search, I have a dynamic sql string being written in my codebehind that references parameters I pass in, such as below: sdsResults.SelectParameters.Add("CodeID", TypeCode.String, strCodeID) My p...
In your workplace, where do you store your common, non-database specific scripts that you use in SQL Server? Do you keep them in .SQL scripts on the file server, do you store them in the Master database, or do you keep them in a database you defined specifically for these kinds of things? ...
I am having problems when connecting to my SQL server 2008 and think it might be a problem related to MDAC. Is there a download to re-install these? ...
Hi, does anybody know how to save and retieve files in MS SQL-Server 2000? I guess the image data type could be used as a container. I want to import/export the following file types: DOC, XLS, PDF, BMP, TIFF, etc. Due to resource issues we are using MS-Access2007 as the front end, so I am looking for VBA code. Thanks in Advance. ...
What does it mean that a Transaction Log is Full? I have it the file set to grow 20% when needed. I have 4GBs left on the drive. How do I solve this issue permanently? Running these commands solves the issue temporarily: DBCC SHRINKFILE('MyDatabase_log', 1) BACKUP LOG MyDatabase WITH TRUNCATE_ONLY DBCC SHRINKFILE('MyDatabase_log', 1) ...
Whenever I write a stored procedure for selecting data based on string variable (varchar, nvarchar, char) I would have something like: procedure dbo.p_get_user_by_username( @username nvarchar(256) as begin select u.username ,u.email --,etc from sampleUserTable u where u.username = @username...
We're having a very frustrating problem in our production environment. We have a report that will sometimes return very quickly, and other times not return at all. When the problem is happening, the report will process for 15 minutes or so then the browser will display a "Cannot display webpage" error. This problem is sporadic usually...