View Full Version : sql server answers


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 [22] 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

  1. Problem in Accessing SQL Server Views from Oracle Using TG4MSQL(Transparent gateway Connectivity)
  2. trigger simple question
  3. un-registering a server
  4. Question: Recording login access to SQL Database
  5. Error when setting up ODBC Connection
  6. Performance monitors
  7. Help with phoneBook db design
  8. Text datatype as local variables in Trigger
  9. Migrating to SQL 2003
  10. Adding Time Totals in SQL
  11. Why I can't drop a table
  12. query plan in clear text
  13. How to copy data from backup or data files to new SQL installation?
  14. dynamically trasnpose rows into columns
  15. Sync to databases nightly with BLOB data
  16. Strange FK relationship - how, and is it right?
  17. maintenace plan question please
  18. Deadlocks and Parallel Query Processing
  19. SQL Debugging Tool
  20. Export Data from SQL Enterprise to SQL Express 2005
  21. *=
  22. 1 question about psql table
  23. Please help the performance issue.
  24. When Linking A Server; Only System Tables Are Accessible!
  25. Database security (crosspost)
  26. Database security
  27. datetime
  28. Help with blocking on querying two joined tables
  29. XOR and foreign key constraints
  30. Toad & S2K5
  31. Transactional Replication
  32. SQL relationships and identities
  33. listing SQL Server databases on a network
  34. Disabling Constraint for Bulk Loading
  35. How to Load SpreadSheet in AxSpreadSheet object in VB.NET or C#.NET
  36. Regarding Index Rebuilding
  37. Help with SQL Query !
  38. Role/Person Table?
  39. Should I worry
  40. Concatenation Limits in SQL Server 2000?
  41. Reporting Services
  42. fix for long running transaction problem
  43. Help with select query
  44. Lock table problem
  45. Need Material for "Sybase to Sql Server Migration"
  46. Replication of several satellites into one central db: adding location key ?
  47. Query Optimization: CPU speed or Logical Reads better?
  48. Query Optimization: CPU speed or Logical Reads better?
  49. Using muliple smaller SPs and Functions better than using 1 big SP?
  50. Nested Nodes in XML from a table
  51. Compile/combine the contents of several records.
  52. Is this an efficient way to create a comma string
  53. Excel file import problem
  54. MSE
  55. Get previous record
  56. help with grouping query...
  57. User Loggon Password Changed
  58. 1 SP with dynamic input parameters and multiple rows as the source of the query
  59. Nested Triggers
  60. Getting data from multiple rows into one column
  61. SP and ADO Page Property Not Working Properly
  62. SLEEPING/AWAITING COMMAND question
  63. error handling and bulk insert
  64. Inserting dummy lines and padding
  65. Planning multiple queries
  66. Mini Index?
  67. Select *
  68. cannont create SSPI context (SQL connection problem after 30 minutes)
  69. Databases not showing up in Enterprise Manager
  70. upgrading to SQL 2005
  71. Help needed by deadlock problem
  72. Can REPLICATION on SQL Server 2000 allow dirty reads
  73. 2000 Replication with DB in 65 Compatibility Mode
  74. Application & Database Security Consultant
  75. Can I install VS.net 2005 / VS.net 2002 / SQL 2005 / SQL 2000 in one PC win2000 sp4?
  76. Why upgrade to MS SQL Server (be it 2000 or 2005) from Access (say, 97)?
  77. Extracting and joining header from denormalized table
  78. HELP: Strange Blocking Performance Problem with Simultaneous Queries
  79. Indexing and Queries
  80. problem creating DTS package
  81. splitting a string
  82. Help needed with query syntax
  83. Clustered versus Create table on high speed FILEGROUP
  84. big log file
  85. String case problem
  86. accessing mssql in linux through c++ code
  87. Index Design Recommendation - Examine Column Uniqueness
  88. Index Design Recommendation - Examine Column Uniqueness
  89. PAGEIOLATCH is a lead blocker
  90. Query question
  91. Monitoring replication
  92. Wildcards On Columns?
  93. Show owner of database
  94. Temp Table and SP Advise
  95. Subtracting two columns from diff tables
  96. LOAD .SQL file
  97. Regarding BCP utility
  98. STORED PROCEDURE - passing table name as a parameter
  99. Passing DateDiff rather than Actual Dates as Parameters
  100. log shipping
  101. Problem with spid by sp_who
  102. Format() Function in MS SQL
  103. Select into / Linked Server / Missing IDENTITY attribute
  104. SQL errors, trapping in Server Agent
  105. multi-field primary key
  106. Bulk Import with header in text file
  107. Data grouped by 20 minutes?
  108. About: An INSERT EXEC statement cannot be nested.
  109. CASE problem
  110. An INSERT EXEC statement cannot be nested error.
  111. Strange Performance question
  112. Can't send operator email in SQL Sever 2005
  113. sql 2000 64-bit
  114. Return pkID of last saved record - ASPUpload & @@Identity
  115. connection TCP/IP through the port 1433
  116. Microsoft SQL 2000 Documenter
  117. Using the copy database wizard
  118. Timeout Period in SQL Server 2005
  119. SQL View Performance
  120. Bulk delete on operational data
  121. Performance when using php and mysql
  122. Query Retrieval is slow
  123. Oracle licensing for dual core processors
  124. SQL backup - dun understand
  125. Prepared SQL Plan vs. Procedure Plan
  126. difficult summing query
  127. SQL Query Help
  128. SQL server - script execution time
  129. Subquery headache with Count and GroupBy
  130. query problem
  131. 100 % CPU Usage
  132. How to move two separate databases into one?
  133. Combining INTO with UNION
  134. Enterprise Manager - problem
  135. Tuning API CURSORS
  136. How to drop one of the tempdb files
  137. SQL Equivalent of MAX and IIF
  138. Need help with Count function and temporary tables
  139. Limit saving DTS package to SQL Server
  140. batch replication
  141. problem with Select query
  142. About bcp_init
  143. Scheduled Job Hangs the server
  144. Active directory and SQL 2K
  145. Scheduled job hangs the server
  146. Compressed folder & Query speed
  147. UBOUND
  148. Recordset
  149. Requirement : IBM Process Choreographer
  150. Hiding secret columns from users
  151. Splitting a filename out of a filepath
  152. verify if database exists
  153. SP 4 error
  154. BULK INSERT and APPLICATION ROLE
  155. About dtsrun
  156. Database Problem related Clusterd data
  157. need a DBA Suggestion.
  158. Make a Bunch of Rows from a Table Resemble a Column
  159. Simple SQL Query (To Neglect time from DateTime DataType)
  160. Alex
  161. Log Invalidated after truncate table
  162. stored procedure with array of parameters
  163. HIT and MISS
  164. SQL Server Msg 1105, Level 17, State 2, Line 1
  165. Query returning 1.7million records slow
  166. Best use of inner join
  167. Is this normal
  168. What looks like a basic SQL query still not resolved
  169. Inner join weirdness in DTS
  170. exam ms 70-228
  171. need help
  172. Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
  173. Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
  174. Optimizing Stored Procedure with Datetime parameter
  175. SQL statement to compute employee pay for a year at different pay rates
  176. adding identity column dynamically
  177. need information on SQL SERVER 2000 with multi-threading CPU
  178. sql query update
  179. There is a question when i work on Linkedserver~Pls kindly help me:)
  180. full text catalog on remote (shared) server
  181. Merge Replication - Adding a new table
  182. QUESTION: Connecting with SQL Admin across domains
  183. Indexes being improperly used when selecting data through a view
  184. SQL-Server DBA-Full Time, Permanent, National Institutes of Health
  185. Optimal search for the nearest date
  186. get the DB index SQL
  187. NEWID()
  188. SQL 2005 Unhandled Exception Error
  189. SQL 2005 Developers Diagram question
  190. flexible back-end data handling in .net + sql project
  191. Query Question
  192. Options to upgrade an SQL 6.5 DB to 2000
  193. DTS package design - Not allaowed link
  194. Is DTS source file's name parameterizable?
  195. Tracking Package Execution Status
  196. Install or not to install Launch Give away version?
  197. Room availability
  198. Concatenating strings from different rows
  199. who knows reporting service
  200. SQL Join with unknown tables - but it works!?!
  201. Star Join
  202. why the MS DTC always stop services automatically ?
  203. SQL server connection problem
  204. working with large numbers
  205. regarding BLOB
  206. How to delete data older than X days, without considering time
  207. Something Basic
  208. Something Basic
  209. Store data horizontally or vertically?
  210. Need security advice on xp_cmdshell, bcp, xml procedure
  211. Linking a table
  212. Simpleton question please
  213. migrating form standard to enterprise edition
  214. how to have the DB diagram
  215. Parse Return value of SYSTEM_USER
  216. DBGEN TPCH Compiling
  217. How to do a JOIN statement for a table with 2, one-to-many relationships.
  218. Bulk Delete
  219. Help with SQL query
  220. Terminal Service cause TimeOut Expired
  221. QUESTION: No Support for SQL 2K on W2K3??
  222. Database optymalization(??)
  223. Filegroup restore problems
  224. Where are the maintenance plans stored in SQL Server 2005?
  225. stored procedure update HUGE PROBLEM
  226. grouping select query
  227. Tables in Parent-Child order
  228. DTS question: 2 source tables, 1 target, 3 connections
  229. Question about Views and sp_refreshviews
  230. Interesting SQL query requirement for <SELECT> menu
  231. Insert
  232. update spends 1800 times more than select
  233. Sql Server 2000 causing TCP/IP to crash?
  234. optional parameter in sql query
  235. commit and rollback problem
  236. tree structure select problem
  237. OpenDataSource trouble with Advantage SQL
  238. newby - AUTOINCREMENT problem.
  239. is WITH ENCRYPTION now safe in SQL2005?
  240. Return Stored Procudure Values
  241. MDF File Still Exists After DROP TABLE
  242. stored procedure
  243. DELETING 100 million from a table weekly SQl SERVER 2000
  244. row level security across multiple columns
  245. BlackBerry Enterprise Server - SQL problem
  246. an unexpected error occured during this operation
  247. mirrored sql servers
  248. How can I tell if a sql server is MSDN or Standard or Enterprise version
  249. sysprocesses memusage sleeping
  250. access MS SQL/ACCESS from linux?
  251. TCP/UDP ports used for Index server OpenQuery
  252. aggregate question
  253. Looking for an opinion
  254. help
  255. Using Query Analyzer with Windows Auth across domains
  256. Whats wrong with my join statement?
  257. Approximate String Searches
  258. Pros / Cons to this approach
  259. learning Microsoft Query Analyzer
  260. Automatic SQL Queries to dump data to folder
  261. Updating a Chunk of data without crashing transaction log
  262. Tables are skipped or export failed error occurs when upsizing MS Access to MS SQL Server
  263. Default charset in sqlserver 2000? / jtds
  264. History of logins or Userids
  265. TPC -H creation script
  266. Torn Page
  267. Is there any REGEXP library for TSQL?
  268. Database design question...
  269. host_name
  270. SQL query question
  271. Unique Constraint on Multiple columns
  272. Stored Procs and db_owner
  273. Information Schema Query Question
  274. Passing authentication from PHP to reporting services
  275. Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
  276. Mira Laura, toma la direccion web,,, dime algo. MS58
  277. Rendering directory structures
  278. question about log file size when alter Huge table
  279. Use DEFAULT CONSTRAINTs or BOUND DEFAULTs?
  280. Problem with HOST_NAME Function with Linked View
  281. Creating Tables on the Fly
  282. have sql file and want to run it on an ftp connection
  283. unique constraint to a column from another table
  284. DTS Table Import Issue
  285. error message 18542 level 16 state 1
  286. Count(*) Locking up things ...
  287. Distinct Filter in SQL Reporting Services
  288. Multiserver Administration
  289. MSDE and two instances on the same server?
  290. Attaching MDF without LDF
  291. Statement for returning stored procedure params
  292. SQL Server 2000 and 8k limit
  293. advice needed on new server product
  294. Find the Data Bases which can not be Backed up are some resons
  295. Find the Data Bases which can not be Backed up are some resons
  296. String manipulation challenge in SQL
  297. Table Synchronization across databases on the same server
  298. How to take data out of table, restructure the table and then put the data back in
  299. DTSRun causes The Memory could not be "read" application error
  300. Server Listing for TCP connection
  301. Identical database w/ identical stored procedures?
  302. Record , Row number
  303. Record , Row number
  304. Deriving unique rows from historical data
  305. too many connections
  306. User Defined Functions, passing parameters from another udf's results (end result=Crosstab)
  307. Tool for clients
  308. Stripping Punctuation
  309. Create Procedure Output ntext
  310. need to replace replication server with main server
  311. DAO > SQL Server Processes
  312. How to select data
  313. Quarterly trending
  314. Quarterly trending
  315. excluding fields in SELECT statement
  316. mssql ide (front ide)
  317. SQL Server 2000 Error 17805 Invalid buffer received from client
  318. Many data entry tables - which ones hold records?
  319. CAST Command
  320. EnterpriseManager-->Process Info Screen
  321. How to create table names by using macro variable? Thanks!
  322. Sql Server 2005: Get a list of all configured Web Services in the "Object Explorer"
  323. historical data
  324. How do I concatenate text to a sql statement
  325. Table Documentor
  326. DTS vs triggers
  327. Synchronising access and sql server
  328. I wish upon a new server ....
  329. Problem with simple cursor
  330. Foreign and primary keys
  331. Adding an auto-increment column to existing table with a particular order
  332. Derived tables from multiple resultsets
  333. MOM blocking analysis
  334. sum of sums
  335. Identifying results sets when stored procedure called multiple times
  336. simple userdefined function question.
  337. Unable to update view in Sql Server 2000
  338. A way to recursively look up hierarchal data using a lookup table
  339. How is inheritence like data best done in SQL
  340. .dat
  341. Certification is not so easy job.
  342. Query help
  343. Moving Data for Audit - Best Practice
  344. Sequence of columns in primary key
  345. How to display just user defined objects?
  346. Creating Primary key with ODBC
  347. Form Slow, Then Fast
  348. SQL UPDATE - PLEASE HELP
  349. Database Access over Internet
  350. How to Interpret Merge Agent History and Session Detail
  351. determine tables that are Simple recovery
  352. Organization tree
  353. MS SQL Server 2000 - Search a table with 300,000+ records in less then a second or two
  354. Wrong default constraint shown from Object Browser in Query Analyser
  355. Tracking user activities
  356. Column By Column Comparison
  357. Relational Database Usage survey
  358. Unique Selections In Back End
  359. Using "SELECT * " is a bad practice even when using a VIEW instead of a table?
  360. Using "SELECT * " is a bad practice even when using a VIEW instead of a table?
  361. Type Mismatch Error On Bulk Insert
  362. Overflow error
  363. Defragment Heap Tables
  364. Bulk insert
  365. Bulk Insert Command
  366. Update One Based on ANother Table
  367. Help with Query
  368. Is logging the execution time of Stored Procedures with standard settings possible?
  369. registering SQL Server not in domain
  370. Problem with SUM
  371. Join statement
  372. Changing the 6th character of a string?
  373. Bulk Insert Data in Millions - Lock Issue
  374. AutoNumber vs. Key
  375. Any way to optimise this query?
  376. embedded control characters
  377. Errors with SP4 upgrade... Please Help
  378. One-One Relationship
  379. ...Contains more than the maximum number of prefixes. The maximum is 3.
  380. Template function
  381. Sql Server backup vs HP Data Protector (HPDP) -- Do *not* use SQL Server?
  382. LIKE and IN can I combine
  383. database in simple mode yet txn log file can be out of diskspace ?
  384. selecting only the last record in joined table
  385. Sooper Newb Ques: Starting with SQL Server 2000 DE
  386. Schema Diff Tool
  387. Dates in a date range
  388. Temp Table on Linked Server
  389. PK and Timestamp in same table?
  390. Backup for one new DB failing in regular maintenance job Error 3201
  391. SQL Import of LArge Amount of Data
  392. question about like
  393. OpenRowSet with Excel DENIED
  394. SQL Convert function!!
  395. changing indexes
  396. SQL for field names from a table
  397. Change Data Type
  398. seeing FMTONLY/NO_BROWSETABLE ON stuff in the profiler
  399. Import cell data from XLS into SQL table
  400. Please suggest backup software
  401. delete of mirrored rows
  402. Joins: strategy and how-to approach
  403. Unique ID added to a result set
  404. how to determine programatically what output of a sp will be?
  405. Display Money Type using + and -
  406. image data type
  407. Transaction Management
  408. resultset of proc in another proc
  409. new sql version control solution!
  410. Search Advice
  411. PostgreSQL Linked Server question
  412. OPENXML vs BCP
  413. my new function not found
  414. Error installing SQL Server2000: A previous program installation created pending file operations on the installation machine
  415. word xp
  416. Calling a Data Pump task from DTS?
  417. copying server objects
  418. Can't "SELECT" using CREATED_DATE column...help
  419. Multiple level nested Corelated query
  420. Problem with case expression
  421. jacek@karczmarczyk.pl
  422. Error handling when calling external sql-Files
  423. Trouble with SPROC
  424. Unit Testing
  425. Autogrow question
  426. Need help formulating a query
  427. ASP.NET + SQL 2005
  428. Query Help, thanks!
  429. How to save DTS package as an application
  430. How to convert from CHAR to Numeric in the table
  431. Horizotal to Vertical Display
  432. How to check Backup of SQL Server Database
  433. Controlling fields in a select statement by use of parameters
  434. NAMED SET / PIVOT TABLE !! HELP ME
  435. Howto set Access Recordsource onto a "select" sproc
  436. HELP MDX , NAMED SET AND PIVOT TABLES !!
  437. SQL Server 2000 Backup + Restore question
  438. SQL Mail setup
  439. SA can not create users
  440. Multiple entries script...help
  441. Database Replication
  442. Transaction log ???
  443. Problem causing me to have to restore tlogs WITH MOVE
  444. Restoring a missing db
  445. Job invoked by Alert but Alert never occured
  446. Fast Date Ranges Without Loops In SQL Server 2000
  447. Howto setup my user in order to grant him the drop privilege
  448. Performance and second table
  449. How to remove MSDE manually?
  450. Can I speed up this script...help?
  451. Stopping Query Execution from PHP
  452. Simple question
  453. Does DBCC DBREINDEX update stats?
  454. Consolidating Records
  455. Finding the most recient datetime
  456. ordering an int column
  457. SQL Server Hanging
  458. date format
  459. Access Control List (structure) invalid - updating Virtual directory information
  460. parsing varchar fields
  461. iSQL - Blank line at the end of the iSql output file
  462. Error : Difference of two datetime columns caused overflow at runtime.
  463. Error : Difference of two datetime columns caused overflow at runtime.
  464. The SMTP Server in xp_smtp_sendmail
  465. Blocking and Transactions OK?
  466. bit off topic: street name database US
  467. Report Services
  468. SQLColumns crash (Access violation)
  469. updating multiple fields
  470. Howto Format a string in a sproc ?
  471. Connecting Trace info to blocked users?
  472. PASS User Group Austria looking for MS-SQL professionals to take part
  473. Is there a way to find growth in log (ldf) and database(mdf) ?
  474. Any way to find out which SP is updating data in a specific table?
  475. min(date) + 1
  476. searching a list of tables, derived from another table
  477. XP and Replication
  478. Help finding the top 3 zipcodes within the top 5 counties
  479. Syntax to add records if primary key = list
  480. Renaming a Server
  481. Is there any way in a sproc to LOOP thru the records of a table ?
  482. inline if
  483. search on concatenated fields in sql server
  484. Original Data and Log size
  485. Rejoining replicating servers
  486. MDF / LDF
  487. Data Load Query
  488. Linked server
  489. Dynamic data elements for a data collection application
  490. Security Admin on a server with NO public permissions
  491. delete records
  492. bcp header
  493. Delete relationship?
  494. Insert based on a select query
  495. DataDirect Technologies Releases DataDirect XQuery to Simplify XML and Relational Data Integration
  496. Single quote in NVARCHAR string?
  497. How to update 1000s of items in 50 tables
  498. Identity...I need to get the last (or highest number in Identity column)...
  499. Stumped by SQL challenge
  500. SQL Server paged recordset problem
  501. SQL 2000 installation on WinXP Pro problems
  502. Can't connect
  503. Scheduling Database - Design Help!
  504. Scheduling Database - Design Help!
  505. Reg Exp for digits
  506. Converting Binary Image to Readable Text
  507. IDENT_CURRENT and empty table
  508. NOLOCK and READPAST on same table?
  509. Determine fastest query in Query Analyzer
  510. Using IS NOT NULL on column result from subquery
  511. Query Syntax help
  512. Aliased column in stored procedure not seen by datagrid
  513. SQL Mail - MAPI profiles on Windows Server 2003
  514. Best way to tell if a SP is a query Programatically
  515. Tools for design recovery (reengineering) of C# source code with embedded sql statements ?
  516. Extremely Slow Table
  517. how to do text replacements
  518. SQL Server bouncing connections
  519. Dont backup if Database hasnt changed
  520. The "right" way to distribute a database to end-user
  521. Why dosn't IIF work here?
  522. saving output from multiple queries
  523. Can someone help me with multiple "Left Outer Joins"?
  524. Can someone help me with multiple "Left Outer Joins"?
  525. Need Help with "Left Outer Join"...
  526. Removing white spaces in a varchar column
  527. Help on a SQL query
  528. oracle pl/sql -> sql server
  529. Index corruption on table without key: what could be the reasons ?
  530. SCOPE_INDENTITY() Not Returning
  531. Script to search for a string in all varchar columns in all tables in a database?
  532. VB 6 & SQL Database: How can I create reports with charts ?
  533. Saving query plan
  534. Output stored procedures as text problem
  535. XML generation issues
  536. How to count
  537. How to override zero rows returned
  538. Monitoring Software
  539. xp_sendmail problem - body message breaking onto new line..
  540. Find the Stored procedure
  541. Round problems in SQL 2000
  542. Changing From Windows To Mixed Authentication
  543. sql datatype help
  544. Systematically determine DRI problem(s)
  545. Any SELECT Statement Gurus Out There?
  546. Import Spreadsheet error
  547. How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log
  548. desinstall MS SQL
  549. XML Tables generation
  550. desinstall MS SQL