Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server-2008
Search options not deleted
user 746
SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.
1
vote
4
answers
1k
views
SQL Query Declaration problem
I have a view as shown below.The View is good running.When I attempt to run view,I got the following the error.What might the problem?
Incorrect syntax near the keyword 'Declare'
SQL Query:
create …
- 1,106
1
vote
2
answers
338
views
Case-sensitive query - SQL Server 2008
How can I rewrite as Latest Developer a record which was created as LATEST DEVELOPER via SQL query?
- 1,106
4
votes
1
answer
738
views
Login problem to SQL Server
I attempt to connect to SQL Server 2008,I receive the following error.
Login failed for user <>. Reason: Failed to open the explicitly specified database.
By the way, I have a SQL Server 2008 R2 …
- 1,106
2
votes
1
answer
1k
views
Issue with SQL Server 2008 replication
I'm doing merge replication between two SQL Server 2008 machine.But,when I attempt to do any modification on system,I got the following error.
The Merge Agent failed because the schema of the article …
- 1,106
2
votes
1
answer
113
views
Full Text Search in SQL 2008
When I attempt to search in the full-text catalog which is my created earlier, I haven't been finding any word within database.
For example:
My word: Where
CONTAINSTABLE(TABLO,*,' "*Where*" ')
H …
- 1,106
2
votes
1
answer
107
views
SQL Server 2000 query error
When I attempt to run on the SQL Server 2000 to a query which was developed for SQL Server 2008, I receive the following the error.
ambiguous column name SucNo
Here is my query:
SELECT
p.Si …
- 1,106
1
vote
2
answers
3k
views
Replication error on SQL Server 2008
I'm doing merge replication between two SQL Server 2008 machine. But, when I attempt to do any modification on subscriber system, I get the following error.
The merge process could not enumerate c …
- 1,106
1
vote
1
answer
6k
views
Linked Server Problem
I have a MSSQL2008 and MSSQL2005 in my system.All SP's is up-to-date.
2008;
Microsoft SQL Server 2008 (SP2) -
10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft
Corporat …
- 1,106
9
votes
1
answer
683
views
How can I rewrite for SQL Server a trigger that writing for Oracle?
How can I rewrite for SQL Server a trigger that was originally written for Oracle ?
Here is my Oracle trigger code:
CREATE OR REPLACE TRIGGER P000KUL_TEST
BEFORE
INSERT
ON P000KUL
REFERENCING NEW AS …
- 1,106
20
votes
7
answers
118k
views
How to drop multiple tables with common prefix in one query?
I'm using Microsoft SQL Server 2008.My question is:How to drop multiple tables with common prefix in one query?
something like that table names:
LG_001_01_STLINE,
LG_001_02_STFICHE
- 1,106
5
votes
3
answers
1k
views
Deadlock Error from SQL Server 2000 to SQL Server 2008
After migrating data from SQL Server 2000 to SQL Server 2008, when I am doing any a transaction in the table which find out more row on the database, that's gives me error.
Transaction (Process I …
- 1,106