Server Configuration
in [Microsoft SQL Server]
|
Looking for a function to declare a table variable I need to declare a table variable from another existing table. If I use "Script table as" will create table variable with [], like CREATE TABLE [dbo].[CLAIM]( [CLAIMNO] [varchar](20) NOT NULL, [ACCT] [varchar](4) NOT NULL, .... Is there a function can return script without [ ]? -- Message posted via SQLMons... 18 May 2010 18:09
SQL2008SP1, maintenance cleanup wont delete I have SQL2008SP1 (10.0.2531), set new maintenance job with cleanup (c:\backup\ and * as extension) Execution is fine, but nothing is deleted. Have some .bak and .7z files in c:\backup\ folder. I know there was a problem in 2005, but SP2 helped. What now? Thank you ... 20 May 2010 03:00
Installing Visual Studio Express 2010 and SQL Express R2 Hi, I tried to install Visual Studio Express 2010 (VB, C#, C++, and Web Develloper), and in the installation it need to install SQL EXPRESS (x64), but it always end up with that it is unable to install SQL EXPRESS So I downloaded the installation from the EXPRESS website, for both x86 and x64, and neither c... 18 May 2010 18:09
How to view a list of values in a single field Hi, I've 2 linked tables (Persona and Attivita) Persona.ID Persona.Descrizione Attivita.ID Attivita.Descrizione PersonaAttivita.IDPersona PersonaAttivita.IDAttivita Each "Persona" can have X "Attivita" I would like to create a SELECT that allow me to show for each "Persona" X Attivita but in... 17 May 2010 18:02
sql200 SQLSERVERAGENT service won't start Rockitman (Rockitman(a)discussions.microsoft.com) writes: Just started happening. Can't understand why. It uses the local system account to login but it can't login. Event Viewer application log states: "SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLS... 17 May 2010 18:02
Error Msg Hi. When I drop the table through query or enterprise manager in sql server 2000 it gives the following error “Server: Msg 7105, Level 22, State 3, Line 1 Page (1:1424), slot 0 for text, ntext, or image node does not exist. Connection Broken” There is no column with the data type text, ntext or image is in... 18 May 2010 18:09
sql200 SQLSERVERAGENT service won't start Just started happening. Can't understand why. It uses the local system account to login but it can't login. Event Viewer application log states: "SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin ... 17 May 2010 18:02
Server: Msg 7105 Hi. When I drop the table through query or enterprise manager in sql server 2000 it gives the following error “Server: Msg 7105, Level 22, State 3, Line 1 Page (1:1424), slot 0 for text, ntext, or image node does not exist. Connection Broken” There is no column with the data type text, ntext or image is in... 17 May 2010 11:20
Server: Msg 7105 Hi. When I drop the table through query or enterprise manager in sql server 2000 it gives the following error “Server: Msg 7105, Level 22, State 3, Line 1 Page (1:1424), slot 0 for text, ntext, or image node does not exist. Connection Broken” There is no column with the data type text, ntext or image is in... 17 May 2010 10:14
Why is "avacodo" not stemmed when using freetext or freetexttable My full text indexed column contains two records, "baseball" and "avacado". I can search on "baseball" and "baseballs" and the record that has "baseball" is returned in both cases. If I search on "avacado" the record with "avacado" is returned. If I search on the plural "avacados", the record with "avacado" is N... 17 May 2010 13:33 |