[SQL Server] Split Database |
| Posted: 28 May 2013 04:15 AM PDT I have a split database that has one Back end and 3 front ends. Is it still possible to migrate over to SQL Server even though I have 3 different front ends accessing that one back end table? |
| Posted: 28 May 2013 01:10 AM PDT Hey all, I have a question from a complete noob to sql. I have a old set up .sql that was written around 2004. I'm trying to use it in server 2008, but it gets a lot of errors. I've been told it's due to language changes since it was written. Here's the contents.# Create the database 'web'# and switch the connection to 'web'CREATE DATABASE web;USE web;# Database: web# Table: 'nwn_sessions'# CREATE TABLE `nwn_sessions` ( `session_id` varchar(32) NOT NULL default '', `session_created` int(11) NOT NULL default '0', `session_active` int(11) NOT NULL default '0', `session_counter` int(11) NOT NULL default '0', `session_remote_address` varchar(128) NOT NULL default '', `session_data` longtext NOT NULL) TYPE=MyISAM; GRANT ALL PRIVILEGES ON web.* TO 'session_user'@'localhost' IDENTIFIED BY 'session_pass';Does that appear to be the case? If so what's involved in changing it over?Thank you for any help!! |
| Hel with a Stored Proc - Date Field Posted: 28 May 2013 12:42 AM PDT Hey guys - I'm running into an issue where SQL Server is barking at me over a syntax issue when testing a stored procedure. The SP simply Inserts a record into a table which contains some date fields.Here's a clip of my SP:[i]ALTER PROCEDURE [dbo].[sp_InsertDealerLocation] ...fields...more fields...@dteLocationLicenseEstDate SmallDateTime,@dteLocationLicenseIssueDate SmallDateTime,...fields...more fields...AS BEGIN TRANSACTIONINSERT INTO DealerLocations(....fields....more fields..., [LocationLicenseEstDate], [LocationLicenseIssueDate],...etc)VALUES(......@dteLocationLicenseEstDate, @dteLocationLicenseIssueDate, ...)[/i]When I test the SP and key in test values into the "Execute Stored Procedure" Window, it fails and informs me of a Syntax error.[i]Incorrect syntax near '-'.[/i]or [i]Incorrect syntax near '/'.[/i]It is referencing the test value/date I key in. Whether it's 5/28/2013 or 5-28-2013. I know dates should be enclosed in a single set of quotes but I thought by defiining the parameter as a Date time, it would not be needed.Any help? Suggestions? Thanks again!! |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment