I added a table tblJoinCustBlastList to a merge replicated database and now I'm getting this failure error during replication: Error messages: The schema script 'if object_id(N'[dbo].[tblJoinCustBlastlist]') is not null exec('ALTER TABLE [dbo].[tblJoinCustBlastlist] ADD CONSTRAINT PK_tblJoinCustBlastlist PRIMARY KEY CLUSTERED ( Joi...
I keep getting this error: Invalid object name "CAccounts". and the code I have is: System.Threading.Thread thread = new System.Threading.Thread(() => { // Set ConnectionString. String sConSg = "CONNSTRING HERE"; using (SqlConnection connection = new SqlConnection(sConSg)) { try { c...
I'm trying to run some queries to a database from a pylons (paster-based) webserver and every time I try to import the pymssql Library I'm using (its this one by the way) I keep getting this error: tds_init_winsock: WSAEnumProtocols failed with 10055(WSAENOBUFS: No buffer space available.) on the import. I also tried using sqlalchemy ...
Dear all, I am using these technologies: SQL Server 2005, ASP.NET MVC, NHibernate/sharp architecture and would like to mine some text with the final aim of presenting some web based stats . I have several millions of keywords and several millions of documents and would like to run some queries based on these documents indexed by the key...
Hi, I'm using Visual Studio 2005 to script out a database so that I can put it in subversion. Now one complaint that I have is that it puts my stored procedure code in a single literal string, like in the example. below. /****** Object: StoredProcedure [dbo].[MyStoredProc] Script Date: 08/19/2010 16:40:14 ******/ SET ANSI_NULLS ON...
I've just migrated from Access where I would "write" SQL constantly and quickly using their GUI layout. I'm very new to SQL Server and am puzzled why is there no query GUI in SQL Server. Is it just that much more powerful that a GUI wouldn't be able to address the majority of queries? Or is it like a purist thing where once one is no ...
I have a page on a server at a remote location that only displays if it is accessed internally. Heres how it works, the page has a button and a list of files, when the button is clicked the script creates a csv file from various database tables and writes it to a folder on the server. The page then refreshes with the new file in the li...
I have a table that looks like this: Project | State ---------------- 1 | A 2 | A 2 | F 3 | A 3 | F 3 | P 4 | S 5 | C What i would like to to is get a table like this : Project | State ---------------- 1 | A 2 | AF 3 | AFP 4 | S 5 | C Is it possible to do...
Hello, Please have a look at the below image before reading my question. If you are not able to view the above picture, please click this link to view the image of the database design and the table data. I want to update the columns like "Parking,AC,TV,locallcalls" in the table "Hotels" with the values from the column "Status" in t...
I do have a cluster with four managed servers with datasources created in the nodes. How would a datasource in some of the managed servers in a weblogic cluster get deleted automatically? ...
I have a problem with changing my spring/hibernate application from MySql to SQL Server. When Hibernate is updating the database by starting the server he want to creates(by hibernate.hbm2ddl.auto set on update ) the database but a foreign-key fails on following error: Unsuccessful: alter table table2 add constraint FKDC2DC97ECEB31922 ...
Hi, I can't find an answer to this so if anyone knows of one please point me in the right direction. A friend has created a few tables for me and used nvarchar(max) on around 4 of the columns in the table. Inserts and Updates are handled using stored procedures. Am I right to worry that the executes of the stored procedures will error...
Can you create a database diagram for a database and save it without creating the actual tables? You know, so the boss can check it out before you apply it? ...
Hello all, I have a SQL Table "Roles" in DB. I want to find out if user have one or more Roles (Admin/User) and then do something with a value if user have 2 Roles at time. Problem: I cant get all Values from Database, I getting just a first one. can I do it with foreach loop? I dont have it here but i'm looking for solution. like: ...
My table Tags has these records Application ID TagName /Blogs A75FB4D9-B0A2-45B1-A58D-9CC4E7FC1482 TagA /News E1BDEF9D-4285-464F-88DC-00495B59D2AE TagA /News 997F1721-335B-477A-9943-B91F0C21DE74 TagB /Blogs BB1CEE87-AF8A-44D6-8A4B-EAB138BBEF10 TagB I want...
I am trying to get only records that are the min date of the orderID I have the following setup: select op.OrderID, op.id, MIN(op.Date) AS Date From OrderPermits op GROUP BY Op.OrderId op.id, MIN(op.Date) AS Date Orders has 1 to many order permits. The problem here is that I am still getting duplicate order Id's when I only want th...
Uploading files from asp.net to SQL Server 2008, after I upload to SQL Server I see the attach content is: 0x89 My stored procedure accepts : @AttachContent varbinary, Below is my code how I am uploading. public bool AttachmentInsert(int mimeTypeId, string attachFileName, byte[] attachContent) { using (...
I've been writing and reading PDF's to a SQL Server 2008 FileStream for a few months now without any major problems (apart from tedious user permissions). Yesterday I had a user inform me that some of their PDF's were being corrupted after being written into the FileStream. So, I did some debugging and I found the problem, but it appears...
I've inherited a stored procedure that uses FOR XML PATH in a subselect to concatenate multiple result rows from the subselect into a single result column on the "main" query. Consider the following, where table "z" is part of the main query's FROM clause: SELECT SUBSTRING((SELECT ('; ' + RTRIM(c.SomeField)) FROM a (NOLOCK) INNER JOIN ...
is there a way to get last record inserted without stored procedure in a multi-user environment? i am connected to sql server through vba. i insert some records and call: SELECT SCOPE_IDENTITY() this is not working. it is returning null every time. here is the entire code: Dim sqlstring1 As String sqlstring1 = "delete from batchin...