Forum: MSSQL

I've got myself into a logic pit. :'( I'm creating a bespoke shop, and I'm going down the route of a product having multiple dynamic attributes (ie, Colour, Size, Texture, etc). My problem comes after assoicating the product with all its attributes. I can't get my head round calculating all...

One of my customers asked me the question whether it's possible to change the collation of a MSSQL database to: SQL_Latin1_General_CP1_CI_AS Can he (or I) do this himself (i.e. using ALTER DATABASE) or do I need the help of RFH for this? The origin of his question is that he wants to move...

Is Sql Server 2008 being considered for RFH? If so, which services/processes are likely to be enabled? Will, for example, the new datatypes, (spatial, filestream) be available? How about the Synch framework? Also, on a similar topic, what aspects of Sql Server (2005) are currently enabled...

Newbie here. Can anyone tell me why some of my SQL tables allow manual deletion of records via MyLittleAdmin while others will not? If it is a setting somewhere, is there any danger attached to having it set to "deletion allowed"? TIA

Hello all, Does anyone have any documentation on setting up Free Text Searching/Full Text Catalogs within RedFox Databases? I can create the Full Text Catalog but I cant assign a table or a field to this, any ideas? Thanks Jon

Not sure this question should be posted here, but since it's a very powerful and important part of web services, shouldn't RS have its own sub-forum? My "real" query regarding RS is this: since elements contained within a PDF can be protected against copying i.e. when produced by packages such...

Firstly, I am new to SQL so be gentle. I have 700,000 records of search data to upload to my database split into tilde '~' delimited files (5000 records per file), I used the ~ due to comma's in the text, I have a connection to my online database using SQL Server Management Express (2005). ...

Here's a fun one... Lets sat you have two tables, one is relational. The relational table might have more than one row for it's parent table. You need to create a left join that will only return one of the relational rows for each record in the parent table...

Is it possible to do a cross database query. Both db are on the same server. If it is can you give me an example. Thanks. Josh

Just wondering if anyone had a good way of dealing with deleting a record in a parent child relationship in a database. For example say you had tblCars CarID Manufacturer Model ColourID

Hello, Right I've just signed up for professional shared hosting, I ve logged into helm but can't see anything to do with databases. I want to get the connection string to my db so I can manag it using sql server management. (or from visual studio 2005 db browser). Sorry, this is probably...

So I was thinking of moving from a PC to an Apple... All my adobe softwares are supported on the Mac, and the switched seemed easy... Then the development hit me... Are there any free and equally useful packages for managing MS SQL like SQL Server Studio Express...

Hi guys, Having a few probs. How do I get a customers ASPNEDBD.MDF file uploaded to the server with ease. Can I create a db name from helm with a diff name as obviously aspnetdb is already a system database. The get the data from the aspnetdb file to the online database???

I'm attempting to send mail through a stored procedure within MS SQL 2000. All the emails are within a table, and I need to scan through each record and send them a mail - I've found an easy solution (http://support.microsoft.com/kb/312839) to send mail without the need of SQL Mail, but...

From this mornings web server logs it appears some nice person from China, has been attempting to use a query string (subsequently used in a select) to attempt multiple selects from other databases. It is indeed good fortune that I don't have admin authority over any other databases other than...

When copying database tables from one SQL database to another blank SQl database, the tables lose their 'identity columns' and become just a normal column and the columns also drop their status as 'primiary key'. Why is this, is there a way to copy a DB from one to another and the tables keep...

Hey Guys, How can I reduce MSSQL ldf log file size? Its now over 145MB while the row size of the database itself is only 15 MB. Since the whole database size is added to the webspace, this really adds up. Any clues?

Has anyone profiled a sql server 2005 database. If so what edition client tools did you install - the profiler does not seem to be available with work group edition.

I am trying to design a query that will return tranactions in my current accounting year. So I have the accounting year start date, 1/4/2007 in a table called accounting_year. The Accounting year will run from the the Year Start Date to 31/3/2008 in this case. I am using...

Hello, The Helm control panel told me to install SQL Server Management Studio Express to work on my Red Fox hosted databases. I got it and installed ot and it works on my own computer, letting me greate and work on databases, but I cannot connect to the hosted database. SQLSMSE opens with...