We have a fairly large database (in SQL Server 2008) with many tables. We have just bought Red Gate's SQL Doc for documentation purposes. We would like to document this database in a detailed way. What is the best practice in documenting a database? How do you document your attributes with definitions? SQL Doc documents the database nice...
I used SQL server 2008 script wizard to create a script that would recreate a database and all its components on a remote server with sql server 2005. Executing it from sqlcmd since its over 8gigs large it ran well until it gave the following error: sqlcmd syntax error at line 40875 at ')' I cannot open the script file to check it sin...
Problem: we need to install SQL 2008 R2 Express with Management tools on about 24 physical machines of various OS flavors. ...
I have a ssis package that does the following copies a file from an ftp to a folder. overwrite if it exists copy data to sql db delete file from ftp i have send email task if the ftp fails. Scheduled this ssis in jobs. I created a 2MB test file and ran the job. Works perfect! now tried with a 500 MB file in the ftp. Works pefect w...
I need to estimate a project to convert a SQL Server 2000 database with database replication to SQL Server 2008. Anyone have thoughts on how I can estimate the level of effort to perform the conversion? I'm thinking of outsourcing the task so that I have the expertise of someone that's been through this before. I would like to estimat...
Is there a way to show table relationships as can be done in Access? Consider two tables: Services serviceid application id Application application id application name I have already set up the diagram. When opening the table service id I want to see the related application details like in Access. Is this possible? ...
I have a SSIS package with a task to load an out-of-process application to bulk-insert data into one table. The problem is that multiple out-of-process applications will run when multiple files arrive at the same time. This will result in insertion failure. Can SQL Server Broker Service queue the inserting data? Does SQL Server or SS...
The aspx.cs Code: the code itself is pretty big, and the code here is fictional, but it looks (the important part) like this: foreach (Transaction trans in vTransactionList) { switch (trans) { case 201: codehere; break; case 202: codehere; break; case 203: ...
Given two scenarios on SQL Server 2008/2005 - 1 Table has 5 rows 2 Table has 1 million rows If we need to update a few rows, what is is efficient and why? 1) UPDATE the required columns 2) DELETE the row and INSERT new row with the updated information ...
Why do I get message that the table needs to dropped and re-created when I add/move columns? I believe this happens after adding foreign key constraints. What can I do to add new columns without dropping table? ...
I am using SQL Server Management Studio. I find it good in a few ways and frustrating sometimes. Which one to you guys use? Preferably something I can try for sometime before I buy... ...
SELECT COUNT(td.timeSheetID) FROM TimeSheet t INNER JOIN TimeSheetDetail td ON t.timeSheetID = td.timeSheetID WHERE (CONVERT(DateTime, t.setDate, 23) BETWEEN '2012-08-10' AND '2012-08-12') AND t.employeeID = 300 The above code returns the value i'm looking for. However, when i do the following, i get nothing: SELECT COUNT(td.ti...
Does SQL Server take over the localization from the server it's installed on? Or can you define the locale for each instance/database? Which setting is responsible for having comma or period when a double is saved to the database? ...
I have a stored procedure in a sql server 2008 db. This stored procedure takes a parameter that is a list of max 5 comma separated integer values. This string is passed through a php sript and formatted like this: 01,02,03,14,15 These values should go in this table: Id | Type id ------------- 1 | 1 1 | 2 1 | 3 1 | 14 1 | 15 ...whe...
I have a VERY simple C# Winforms project that I made using Visual Studio 2010. It uses SQL Express 2008. This is my first time using SQL, so I wanted a hands-on approach to learning SQL, and this project allowed me to do that. I want to post my project on my website for people to see. However, I have stored procedures, constraints, and ...
I need to implement a data structure in C#/SQL Server that is a little bit tree and a little bit graph. I can think of how to brute force this, but performance is very important. That is where I need help. Here are the requirements: 1) There are n root nodes. 2) Each node can have n children. 3) Each node is a list. 4) Each node can...
Why transaction does not rollback Identity column. I have a table named "DetailReports" which has one Identity column. There are some SPS which manage data of DetailReports. Transactions are there based on condition now issue is that when we call rollback of transaction then we are not getting rollback of identity column. If its the natu...
Hi All I am developing a dimension table, the requiremnet is to insert all possible unique combinations of source attribute. step1: I took source with row_number() functions to get the duplicate records as row number step2: conditional split used to take onlt row == 1 so I am taking all uniqe possible records from source in the initia...
Hai all, I am doing c#.NET application to calculate different formulas and give result to user,users can enter any formula and each formula values are stored in database like this. After saving like this i want to calculate the result.When calculating the result,application ask values for variables.But how can i calculate with this ...
I'm working on a project in .NET 4.0 against an SQL Server 2008 Database. The system uses some legacy code, originally written in .NET 2.0 (converted to 4.0). Running locally everything works fine, but when I moved the code to the test environment I get the following confusing error from the legacy code: Exception class: System.Argume...