Hi, I'm developing an applciation using SQL Compact database in Visual Studio 2008. When I start the application and run the process, the data is being loaded into database for few hours worth of few tens of megabytes. However, when I quite debugging, change something in code (not in DB structure), run the project again, the database is...
I'd like to give users the ability to search through a large list of businesses, but still find near matches. Does anyone have any recommendations on how best to go about this when you're not targeting simple dictionary words, but instead complex names like ABC Business Name? Regards. ...
Hi, I need to set up a system which will allow developers to request an emergency ID for a database. They will be assigned to a role called 'analyst' which will provide them a drop down box with the databases they can gain access to. They will submit the request and a temporary SQL Login will be generated and displayed on screen. The ...
I receive this error sporadically throughout the day. According to the stack, it's thrown during enlistment. If it were getting this error every time I'd be able to troubleshoot and fix (typically a firewall or LMHOSTS issue). Since it's randomly happening, I can't for the life of me think about what would do this. Any ideas? System...
I have been experiencing an error that I believe is caused by the database timing out due to a large amount of data being processed and read to the database. I keep getting this error message: Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. I timed how long it takes t...
Executing SP to check who is currently logon in the SQL working fine in Development database.But executing same SP in LIVE database only return 1 "runnable" record. Both databases are reside in same physical SQL server. Had compare 2 database using some external freeware and shareware, can't find any difference especially on "Users and...
Good day, When creating a new table in SSMS - right click on the "Tables" node, choose "New Table..." - the default definition for a new column is nchar(10). Can I change that? Let's say I would like the default column definition to be varchar(5) whenever someone creates a new table. I can't find any sort of option to change that, I'...
I'm working on a modification to a site to allowing users to enter content. However, once they've created that content it needs to be approved before it can be published. This is fairly easy to achieve by having a "moderate" bit set in the record for that content and only one table is needed. Now I also want to allow users to edit the c...
I have a table in SQL Server 2008 that looks kind of like this: ID I1 I2 ... IN ------------------------- 1 2 3 ..... 2 2 0 0 ..... 0 3 2 1 ..... 5 Where IN is about 9 columns. What I need to do is count the number of rows, but skipping rows where the values of I1..IN are 0's. I'm new to SQL and I have basically...
In this procedure, I want to delete those number which coming in @msisdn from Master Table and insert into tblDeactive: ALTER PROCEDURE [dbo].[msisdn_deactivition](@msisdn varchar(1024)) AS BEGIN SET NOCOUNT ON; insert into tblDeactive SELECT * from msisdn_master where msisdn in (@msisdn); delete from msisdn_master where msis...
I have a process where data is transferred from an Excel spreadsheet into SQL Server. To do this, I've created a dtsx using the SQL Server Import / Export Data wizard. The trouble is, the script could be run against any database. But the wizard seems to default to using the format CREATE TABLE [Database].[dbo].[table] when creating th...
i got error when i run exec sp_changeobjectowner 'testtable','dbo' 'testtable' table - Unable to modify table. The object with name "testtable" already exists. ...
Is MS SQL other than SQL Server ? ...
I'm using Microsoft's SQL Server 2000 and have a query that is essentially this (except that Z is a further subquery, not a table): select A.key1, A.key2, B.value1 from A left join (select * from Z where value1 > 0) B on A.key1 = B.key1 and A.key2 = B.key2 order by A.key1, B.key1 Column value1 is of type float. For some reas...
I want Microsoft SQL server queries corresponding to the following Oracle queries //get schema of a table desc tablename; //get the names of all tables select * from tab; ...
I've got a simple query running against SQL Server 2005 select * from Table where Col = 'someval' The first time I execute the query can take > 15 secs. Subsiquent executes are back in < 1 sec. How can I get SS2005 not to use any cached results. I've tried runnning DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE but this seems to have no...
SQL Server 2005: 240 million row table. Column requirements changing from NOT NULL to NULL. Generally bad practice (and often impossible) to use ALTER statements when dealing with tables this big, however, trying to avoid rebuilding the table, if possible. Tested ALTER statement against a dev table containing 20m rows, and the statem...
I am working on a issue tracking application with asp.net and sql server 2005. While tracking the issues I am storing the deadline as datetime in the database and also if someone posts a message in the message board the posting date/time is also getting stored in the db as datetime. Now my requirement is to show the issue deadline as "2...
I have several tables (to be exact, 7) tables I cross join in one another. This part gives me some problems; Table "Actions" ----------------------------------------- | ID | Package ID | Action Type | Message | ----------------------------------------- | 40 | 100340 | 0 | OK | | 41 | 100340 | 12 | Erro...
I get a strange behaviour when I combine impersonation with database links in SQL Server 2005. First, I connect to a database server using simple SQL Server Authentication with Login 'John'. On this server, a server link remote_sqlserver is defined. I already have SELECT privileges for mydb in this server. When I simply query a table on ...